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!

how to convert timestamp

535323Nov 27 2006 — edited Nov 28 2006
may i know how to convert timestamp to date (dd/mm/yyyy)?
i did try to_date(movementdate, 'dd/MM/yyyy'). but it didnt work as it still display dd/mm/yyyy hh:mm.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2006
Added on Nov 27 2006
17 comments
601 views