Skip to Main Content

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!

Display date without time stamp

76a6d43b-ab99-4134-bbc6-85a44c7db241Sep 20 2017 — edited Sep 20 2017

I'm trying to display a date without the timestamp at the end.    I've tried to_date, pfdate, string, substring with no luck.   Any ideas?

to_date(wstime, "DD-MM-YYYY').  I've tried to define it as a string and a date but it still appears with the time at the end.  

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2017
Added on Sep 20 2017
7 comments
14,904 views