Random MySQL Dates 2007-03-29 04:38pm
Here is a good way to generate a random date that you can use in MySQL.
SELECT FROM_UNIXTIME(RAND() * 2147483648) AS MyDate;
or
INSERT INTO TableName (DateField) VALUES (FROM_UNIXTIME(RAND() * 2147483648));




