Keep in mind: a UNIX timestamp is simply the amount of milliseconds until the 01.01.1970 00:00:00.000 If you want to move it one hour later you have to add (1*60*60*1000) to your long typed timestamp. One of the problem is to know from which timezone is your timestamp.
hi vicky, first convert your string variables to double . using Double.parseDouble(column_name) then in tmap you can directly use the below expression to get date : new java.util.Date((long)(Column_Name*1000)) the above expression will convert your unix date into actual date pattern. please let me know incase of any doubts. with regards, Akash S.
Dear Users, Can anyone explain step by step how to load data from flat file into teradata using tteradataTPT component , i tried but i am uanble to do so..i referred to online docs but its not helpful also few forums Please help its v urgent Thanks Amit