随机生成2014/05/01到现在的时间

1
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP('20140501000000') + ROUND(RAND()*(UNIX_TIMESTAMP() - UNIX_TIMESTAMP('20140501000000'))));