Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT TO_DATE('0000-00-00 00:00:00', 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;
ORA-01843: not a valid month

SELECT TO_DATE('0000-01-00 00:00:00', 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;
ORA-01847: day of month must be between 1 and last day of month

SELECT TO_DATE('0000-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;
ORA-01841: (full) year must be between -4713 and +9999, and not be 0