16 digit epoch time to timestamp

Five Stars

16 digit epoch time to timestamp

Hi,
I have a input field which has 16 digit timestamp. how can i convert it into timestamp.
i saw other posts related to the topic but there epoch timestamp was of 10 digit.
Any help ?
Thanks & regards,
Jugal
Five Stars

Re: 16 digit epoch time to timestamp

1120326200041000 is an example of the input field
Seventeen Stars

Re: 16 digit epoch time to timestamp

Please take al look at the Java doc of the class SimpleDateFormat. This class is in use also in the Talend routines.
http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
In the database you have to create the timestamp with a length expression like e.g. timestamp(12) but this depends on the database type.