MySQL生成随机时间
随机生成2014/05/01到现在的时间
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP('20140501000000') + ROUND(RAND()*(UNIX_TIMESTAMP() - UNIX_TIMESTAMP('20140501000000'))));
随机生成2014/05/01到现在的时间
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP('20140501000000') + ROUND(RAND()*(UNIX_TIMESTAMP() - UNIX_TIMESTAMP('20140501000000'))));