select FROM_UNIXTIME(
UNIX_TIMESTAMP('2022-01-01 00:00:00') + FLOOR(RAND() * (UNIX_TIMESTAMP('2022-12-31 23:59:59') - UNIX_TIMESTAMP('2022-01-01 00:00:00')))
)
mysql 获取指定时间段内随机值
最新推荐文章于 2024-05-19 03:18:57 发布
select FROM_UNIXTIME(
UNIX_TIMESTAMP('2022-01-01 00:00:00') + FLOOR(RAND() * (UNIX_TIMESTAMP('2022-12-31 23:59:59') - UNIX_TIMESTAMP('2022-01-01 00:00:00')))
)