Random MySQL Dates

Here is a good way to generate a random date that you can use in MySQL.

SELECT FROM_UNIXTIME(RAND() * 2147483648) AS MyDate;


INSERT INTO TableName (DateField) VALUES (FROM_UNIXTIME(RAND() * 2147483648));

Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
Logged IP:
To prevent spam please submit by clicking the kitten: