SELECT FROM_UNIXTIME(RAND() * 2147483647) AS `rand`;
+---------------------+

| rand                |

+---------------------+

| 1998-04-01 21:42:48 |

+---------------------+
http://www.phpied.com/random-mysql-date/