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
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.