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!

Why is it that TO_DATE can not implicit convert string to date while SELECT DATE can?

ben-from-canberraDec 28 2023 — edited Dec 28 2023

If my session's NLS_DATE_FORMAT is set to DD Mon YYYY.

Why is it that SELECT DATE '2019-01-01' FROM DUAL; work fine.

While SELECT TO_DATE('2019-01-01') FROM DUAL; give a ORA-01861: literal does not match format string error?

source: ExamTopics_1Z0-071_107
Comments
Post Details
Added on Dec 28 2023
3 comments
762 views
1 mention