The value obtained by sysdate is
Declare
WDT_DATE: = SYSDATE;
Begin
DBMS_OUTPUT.PUT_LINE (TO_CHAR (WDT_DATE 1, 'YYYYMMDD'));
END;
If you need to add an hour
Then
Declare
WDT_DATE: = SYSDATE;
Begin
DBMS_OUTPUT.PUT_LINE (TO_CHAR (WDT_DATE 1/24, 'YYYYMMDD'));
END;
