MySQL 8.0

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

Now
2025-08-12 14:20:31

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-08-08	2025-08-01 03:46:47.000000
2025-08-12	2025-08-03 09:24:48.000000
2025-08-09	2025-08-10 15:45:21.000000
2025-08-12	2025-08-02 13:33:35.000000
2025-08-05	2025-08-07 10:45:17.000000
2025-08-08	2025-08-05 01:13:22.000000
2025-08-03	2025-07-30 13:21:33.000000
2025-08-05	2025-07-31 17:44:30.000000
2025-08-03	2025-08-02 15:46:46.000000
2025-08-04	2025-07-31 11:03:17.000000