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!

Sorting Timestamp

Stanley Lee-OracleFeb 16 2010 — edited Feb 16 2010
Hi,

I just want to sort the timestamp datatype in a format I would like.

SELECT
to_char(COLUMNTIMESTAMP,'YYYY-MM-DD HH24:MI:SS') FROM DBTABLE

Should I use to_char or to_date?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2010
Added on Feb 16 2010
2 comments
1,494 views