Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'MMDDYYYY HH24:MI:SS';
SELECT TO_DATE(
         TRUNC(
           DBMS_RANDOM.VALUE(
             TO_CHAR(DATE '2021-01-01','J'),
             TO_CHAR(DATE '2022-12-31','J')
           )
         ),
         'J'
       )
       + NUMTODSINTERVAL(
           FLOOR(DBMS_RANDOM.VALUE(0,86399)),
           'SECOND'
         )
FROM   DUAL;


TO_DATE(TRUNC(DBMS_RANDOM.VALUE(TO_CHAR(DATE'2021-01-01','J'),TO_CHAR(DATE'2022-12-31','J'))),'J')+NUMTODSINTERVAL(FLOOR(DBMS_RANDOM.VALUE(0,86399)),'SECOND')


04122021 04:50:14


SELECT DATE '2021-01-01'
       + NUMTODSINTERVAL(
           DBMS_RANDOM.VALUE(0, DATE '2022-12-31' - DATE '2021-01-01' + 1),
           'DAY'
         )
FROM   DUAL;


DATE'2021-01-01'+NUMTODSINTERVAL(DBMS_RANDOM.VALUE(0,DATE'2022-12-31'-DATE'2021-01-01'+1),'DAY')


11122022 23:41:07


SELECT DATE '2021-01-01'
       + DBMS_RANDOM.VALUE(0, DATE '2022-12-31' - DATE '2021-01-01' + 1)
FROM   DUAL;


DATE'2021-01-01'+DBMS_RANDOM.VALUE(0,DATE'2022-12-31'-DATE'2021-01-01'+1)


05162022 07:18:22