生成時間随機數sql

update 表名

set

時間字段名= FROM_UNIXTIME(UNIX_TIMESTAMP(DATE_ADD(DATE_ADD(‘2020-10-01 10:00:00’,INTERVAL FLOOR(1+RAND() * 28800) SECOND), INTERVAL FLOOR(1+RAND() * 90) DAY)),’%Y-%m-%d %T’)

WHERE id between 1 AND 129104;