Random date/time Need to generate a random date in MySQL? Here: mysql> SELECT FROM_UNIXTIME(RAND() * 2147483647) AS `rand`; +———————+ | rand | +———————+ | 1998-04-01 21:42:48 | +———————+ 1 row in set (0.00 sec) Let’s try once again and get a different random value: mysql> SELECT FROM_UNIXTIME(RAND() * 2147483647) AS `rand`; +———————+ | rand | […]