topic Re: 16 digit epoch time to timestamp in Talend Studio https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374642#M137210 Please take al look at the Java doc of the class SimpleDateFormat. This class is in use also in the Talend routines. <BR /> <A href="http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html" rel="nofollow noopener noreferrer">http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html</A> <BR />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. Sat, 01 Mar 2014 15:17:33 GMT Anonymous 2014-03-01T15:17:33Z 16 digit epoch time to timestamp https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374640#M137208 Hi,<BR />I have a input field which has 16 digit timestamp. how can i convert it into timestamp.<BR />i saw other posts related to the topic but there epoch timestamp was of 10 digit.<BR />Any help ?<BR />Thanks &amp; regards,<BR />Jugal Wed, 04 Apr 2012 13:40:09 GMT https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374640#M137208 djugal 2012-04-04T13:40:09Z Re: 16 digit epoch time to timestamp https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374641#M137209 1120326200041000 is an example of the input field Wed, 04 Apr 2012 13:57:56 GMT https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374641#M137209 djugal 2012-04-04T13:57:56Z Re: 16 digit epoch time to timestamp https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374642#M137210 Please take al look at the Java doc of the class SimpleDateFormat. This class is in use also in the Talend routines. <BR /> <A href="http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html" rel="nofollow noopener noreferrer">http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html</A> <BR />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. Sat, 01 Mar 2014 15:17:33 GMT https://community.qlik.com/t5/Talend-Studio/16-digit-epoch-time-to-timestamp/m-p/2374642#M137210 Anonymous 2014-03-01T15:17:33Z