conversion of string to timestamp with microseconds
Posted: 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.
[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.