Stepwise-Lab

ORA-01861: Literal does not match format string

A string was converted to a date with a format model (often the session's NLS_DATE_FORMAT) it does not match. Use a DATE '2024-01-31' literal or TO_DATE with an explicit format.

On the exam

This error belongs to the topic Conversion and conditional of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors