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';
SELECT DATE '2021-01-01'
+ DBMS_RANDOM.VALUE(0, DATE '2022-01-01' - DATE '2021-01-01')
AS random_date
FROM DUAL
CONNECT BY LEVEL <= 10;
| RANDOM_DATE |
|---|
| 2021-11-25 00:53:13 |
| 2021-08-28 22:33:35 |
| 2021-02-11 23:28:50 |
| 2021-12-10 05:39:00 |
| 2021-01-10 22:02:47 |
| 2021-01-01 16:39:13 |
| 2021-10-30 20:58:21 |
| 2021-03-14 06:27:34 |
| 2021-10-11 00:24:03 |
| 2021-04-20 03:53:54 |