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!

Question on date format mask

RNAug 1 2019 — edited Aug 5 2019

Hi all,

I tried on 11g and 18c:

select TO_DATE('7/18/19','MM/DD/YYYY') from dual;

--result is 20-JUL-19

Why it gave 20-JUL and not 18-JUL? Please help.

Thanks,

This post has been answered by mathguy on Aug 1 2019

Jump to Answer

Added on Aug 1 2019

35 comments

1,178 views