update ads_taxpayer_d set location_date=timestamp '2017-01-01 20:10:10' + random() * (
registration_time - timestamp '2017-01-01 20:10:10'
) where location= '1'
postgresql 生成某段时间内的随机时间
最新推荐文章于 2024-06-27 15:47:01 发布
update ads_taxpayer_d set location_date=timestamp '2017-01-01 20:10:10' + random() * (
registration_time - timestamp '2017-01-01 20:10:10'
) where location= '1'