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!

PL SQL Date Query returns invalid date format

Mark_PaxMay 31 2016 — edited Jun 1 2016

Good day,

I have been battling with an Oracle date issue fro a while now and I cant seem to get it to work.

I have field called 'DATE_CREATED' but when I run the Select query ' Select DATE_CREATED' from DB, I get the results below.

date20160517 month052016 time203956 min2039 hour20

What I would like to see is 17-MAY-2016 20:39:56 or 17-MAY-2016 08:30 PM

I tried every thing from TO DATE(DATE_CREATED, 'DD-MON-YYYY HH24:MI:SS').

No luck.

Please help.

Regards,

Mark

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2016

Added on May 31 2016

13 comments

2,494 views