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!

Unix Timestamp to date

787449Jul 26 2010 — edited Jul 26 2010

hi,

I am using SQL developer to query an oracle 8 Database and
I need to convert a unix timestamp to a specific date time format - YYYYMMDD HH24:MI:SS

I am currently using
,to_date('19700101 00:00:01','YYYYMMDD HH24:MI:SS')+sh.order_date/86400

but this just returns the date in the format DD-MMM-YY

This post has been answered by 21205 on Jul 26 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2010

Added on Jul 26 2010

#sql

4 comments

3,836 views