Hi All,
how to convert timestamp format
Inlink.Field1
2008-09-06 20.30.156546
Outlink.Field1
2008-09-06 08:30:15 PM
I had tried using Iconv and Oconv like..
Oconv(Iconv(Inlink.Field1,'D-YMD[4,2,2] MTS.'),'D-MYD[4,2,2] MTHS')
the above derivation not returning any values to the Outlink.Field1
Any suggestions are most welcome
Thanks in advance
how to convert format timestamp
Moderators: chulett, rschirm, roy
Hi chulett,
Thanks for your response,
but I noticed that while executing query from a oracle its displaying like
Inlink.Field1
2008-09-06-20.30.355465
what I had posted is not the one to be converted.
I could not able to make a query in oracle itself. But while running the datastage job and populating into oracle table having the datatype timestamp. Its output is like
Outlink.Field1
2008-09-06 08:30:35 PM
Its converting by itself but I need to define my conversion as
Outlink.Field1
2008-09-06 20:30:35
please any one can light me up
Thanks in advance
Thanks for your response,
but I noticed that while executing query from a oracle its displaying like
Inlink.Field1
2008-09-06-20.30.355465
what I had posted is not the one to be converted.
I could not able to make a query in oracle itself. But while running the datastage job and populating into oracle table having the datatype timestamp. Its output is like
Outlink.Field1
2008-09-06 08:30:35 PM
Its converting by itself but I need to define my conversion as
Outlink.Field1
2008-09-06 20:30:35
please any one can light me up
Thanks in advance