MySQL 8.0

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

Now
2025-01-30 12:36:42

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-01-18	2025-01-21 00:21:28.000000
2025-01-20	2025-01-19 12:57:52.000000
2025-01-22	2025-01-19 09:35:55.000000
2025-01-29	2025-01-30 00:11:09.000000
2025-01-17	2025-01-22 19:38:20.000000
2025-01-17	2025-01-28 17:57:38.000000
2025-01-20	2025-01-24 02:59:28.000000
2025-01-17	2025-01-22 21:40:57.000000
2025-01-20	2025-01-27 07:32:33.000000
2025-01-19	2025-01-24 02:39:20.000000