conversion of string to timestamp with microseconds

devesh_ssingh · Post by **devesh_ssingh** » Wed Jul 02, 2008 3:30 am

Function used in transformer ---> StringToTimestamp(XMLInput_db_tgt_ln.EVENTTIME
[1,10] : ' ' : XMLInput_db_tgt_ln.EVENTTIME [12,8] : '.': XMLInput_db_tgt_ln.EVENTTIME[14,6],"%yyyy-%mm-%dd %hh:%nn:%ss.6")

This funtion i have used .but i am not getting the actual output.My output is 2008-06-25 08:57:36.000000.i need the following input result

Required output--->2008-06-25 08:57:36.008938.

ArndW · Post by **ArndW** » Wed Jul 02, 2008 5:12 am

The target column attribute "Extended" for milliseconds needs to be enabled.