Creating a Random Date in MySQL

The following code can be used to create a random date between 1930-01-01 and 2010-01-01.

SELECT '1930-01-01' + interval rand() * 29200 day;