topic Re: convert unix timestamp to different time zone in Talend Studio

convert unix timestamp to different time zone

Anonymous — Sat, 16 Nov 2024 11:46:32 GMT

Hi All,
we have csv file.
ts
1390207663
1390208083
1390208383
1390208743
we want to convert timestamp values to another timezone timestamp?

Thanks in advance
vicky

Re: convert unix timestamp to different time zone

Anonymous — Wed, 22 Jan 2014 20:58:55 GMT

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.

Re: convert unix timestamp to different time zone

Anonymous — Thu, 23 Jan 2014 08:35:18 GMT

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.

Re: convert unix timestamp to different time zone

Anonymous — Tue, 05 Jan 2016 17:45:59 GMT

Hello,
I want to convert the unix timestamp 1443696342801 into date ,
i am new to Talend , i converted 1298226724 into date using below logic , please see below attach screen shots:

But i am unable to convert this number 1443696342801
any suggestion will be helpfull
its little urgent
thanks
Amit

Re: convert unix timestamp to different time zone

Anonymous — Wed, 06 Jan 2016 07:42:10 GMT

Hi Amit,
We have replied to your another topic: https://community.talend.com/t5/Design-and-Development/convert-the-unix-timestamp/td-p/83249. Could you please take a look at it?
Let us know if it is Ok with you.
Best regards
Sabrina

Re: convert unix timestamp to different time zone

Anonymous — Sat, 16 Jan 2016 19:42:03 GMT

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

Re: convert unix timestamp to different time zone

Anonymous — Mon, 18 Jan 2016 10:11:29 GMT

Hi Amit,
We have replied your another topic in: https://community.talend.com/t5/Design-and-Development/Need-help-on-tTeradataTPT-component/td-p/85008. Could you please take a look at it?

Best regards
Sabrina