Return
-
Title
Executing TO_DATE() in the Toad Editor gave error "ORA-01841" in TOAD. -
Description
If I run a query (F5 or F9) with the TO_DATE() conversion in Toad, I get an
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
For example,
SELECT TO_DATE (T.DATE_OF_BIRTH, 'DD-MON-YYYY') FROM T;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.