Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Timestamp format for SQL Server data

407338Jul 19 2006 — edited Jul 19 2006

Hi all,
I put this question on the PL/SQL forum but got no answer yet. Could anyone help me with the timestamp format for a timestamp data from SQL Server? I have this in the xml from SQL server,

2006-06-20T00:00:00-05:00

and I need to make it a date or timestamp data type in Oralce. I have looked at the docs and could not find the correct format for this. Please note there is a T in the middle and I don't know why it is there and what it is for.

Thanks.

Ben

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2006

Added on Jul 19 2006

#performance-availability, #xml-db

4 comments

574 views