Oracle 18c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF9';
ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF9TZR';
SELECT SYSDATE, SYSTIMESTAMP FROM DUAL;


SYSDATE
SYSTIMESTAMP


2024-07-01 01:27:38
2024-07-01 01:27:38.629859000+01:00


SELECT SYSDATE - 1, SYSTIMESTAMP - 1, SYSTIMESTAMP - INTERVAL '1' DAY FROM DUAL;


SYSDATE-1
SYSTIMESTAMP-1
SYSTIMESTAMP-INTERVAL'1'DAY


2024-06-30 01:27:38
2024-06-30 01:27:38
2024-06-30 01:27:38.632773000+01:00