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!

How to convert varchar to timestamp

saranya.aDec 20 2012 — edited Dec 21 2012

in the db , i have a column indtalledDate with datatype varchar-- and value is like 'Thu Dec 20 07:33:20 PST 2012'. Now i need to convert this to timestamp format-->20-DEC-12 07.47.49.463000000 AM . how can i do?

can anyone pls help???

This post has been answered by Manik on Dec 20 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2013

Added on Dec 20 2012

4 comments

190 views