Hi ,
I am trying to convert the date which is in "2006-04-27T12:38:57.000Z "
format to Timestamp in oracle.
please let me know how iconv , oconv are useful here.
In the source the column is Varchar2.
In the target the column is timestamp.
Both source and target are oracle.
thanks in advance.
Time stamp issue
Moderators: chulett, rschirm, roy
Are you sure your target a TIMESTAMP in Oracle and not a DATE field? If so, please post the full definition of the TIMESTAMP field which would include the precision.
Also, are you sure about your source date? I've seen similar Internet/XML date formats before, which typically involves swapping the 'T' with a space to 'transform' it. Wondering about the 'Z'... that usually is included in a 'TimeZone' element, from what I recall. You sure there is always just a trailing 'Z' as part of your timestamp?
Please also post how you have tried to convert the date so far.
Also, are you sure about your source date? I've seen similar Internet/XML date formats before, which typically involves swapping the 'T' with a space to 'transform' it. Wondering about the 'Z'... that usually is included in a 'TimeZone' element, from what I recall. You sure there is always just a trailing 'Z' as part of your timestamp?
Please also post how you have tried to convert the date so far.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers