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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Added on Dec 28 2023

3 comments

541 views

1 mention