Skip to Main Content
Forums

SQL & PL/SQL

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!

Convert YYYY-MM-DDTHH:mm:ss.000Z format to Date

StephenDec 22 2009 — edited May 2 2011
Hi,

I have a varchar2 field which stores date in the following structure '2009-12-22T23:45:57.000Z' and need to convert to a date format 'MM-DD-YYYY HH:MM:SS' How can I achieve this?

Thanks
VJ
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2011
Added on Dec 22 2009
3 comments
25,297 views