By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT CURRENT_TIMESTAMP AS Now;
| Now |
|---|
| 2025-03-14 16:46:12 |
SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY AS 'Random date in the past 2 weeks', CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND AS 'Random date & time in the past 2 weeks'
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
UNION ALL SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND
| Random date in the past 2 weeks | Random date & time in the past 2 weeks |
|---|---|
| 2025-03-08 | 2025-03-01 09:48:01.000000 |
| 2025-03-09 | 2025-03-10 20:33:52.000000 |
| 2025-03-13 | 2025-03-05 07:35:37.000000 |
| 2025-03-14 | 2025-03-11 00:15:59.000000 |
| 2025-03-12 | 2025-03-01 01:47:10.000000 |
| 2025-03-09 | 2025-03-13 00:36:36.000000 |
| 2025-03-09 | 2025-03-07 12:35:00.000000 |
| 2025-03-08 | 2025-03-05 10:39:33.000000 |
| 2025-03-01 | 2025-03-01 10:20:40.000000 |
| 2025-03-04 | 2025-03-13 21:40:53.000000 |