clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3799354 fiddles created (41681 in the last week).

SELECT TO_TIMESTAMP(sysdate) FROM dual
TO_TIMESTAMP(SYSDATE)
20-FEB-20 12.00.00 AM
 hidden batch(es)


ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF9';
 hidden batch(es)


SELECT TO_TIMESTAMP(sysdate) FROM dual
TO_TIMESTAMP(SYSDATE)
0020-02-20 00:00:00.000000000
 hidden batch(es)


ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'FXYYYY-MM-DD HH24:MI:SS.FF9';
 hidden batch(es)


SELECT TO_TIMESTAMP(sysdate) FROM dual
ORA-01862: the numeric value does not match the length of the format item
 hidden batch(es)