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 a column with a timestamp in number format to date

user12945439Feb 13 2012 — edited Feb 13 2012
Hi all,

I've a table with a column, format NUMBER, that contain in fact a TIMESTAMP WITH TIMEZONE.
I'm trying to convert into a date readable.

Using CAST(mycol as VARCAHR2(30)) I'm able to convert it into text. But I'm not able from here to convert it to a date.
Any date?

Thanks
S
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2012
Added on Feb 13 2012
#11g, #date
11 comments
18,337 views