Oracle 11g Release 2

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

select sysdate from dual

SYSDATE

27-APR-23

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual

TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI:SS')

2023-04-27 03:05:12

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss.ff') from dual
ORA-01821: date format not recognized

select systimestamp from dual

SYSTIMESTAMP

27-APR-23 03.05.12.622817 AM +01:00

select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff') from dual

TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DDHH24:MI:SS.FF')

2023-04-27 03:05:12.628138