mysql生成时间段内的随机时间
函数:
DECLARE sub INT DEFAULT 0;DECLARE ret DATETIME;SET sub = ABS(UNIX_TIMESTAMP(ed)-UNIX_TIMESTAMP(sd));SET ret = DATE_ADD(sd,INTERVAL FLOOR(1+RAND()*(sub-1)) SECOND);
?
测试:
SELECT RandomDateTime(DATE_FORMAT('2010-12-1 10:10:10','%Y-%m-%d %H:%i:%s'),DATE_FORMAT('2010-12-1 11:10:13','%Y-%m-%d %H:%i:%s')) AS t;
?
?