sql在两个日期之间随机更新 [英] sql update random between two dates

问题描述

我尝试更新我的数据库并更改日期.我做了一些研究，但没有发现任何问题.所以我用了两个时间戳.

I've tried to update my database and changing dates. I've done some research but I did not found any issue. So I used two timestamp.

我尝试过这种方法:

UPDATE `ps_blog_post` 
SET `time_add` = ROUND((RAND() * (1387888821-1357562421)[phone]))

现在到处都是新日期:

0000:00:00

任何形式的帮助将不胜感激

Anykind of help will be much appreciated

推荐答案

您的想法是正确的，您从正在使用的 int 文字转换回时间戳的转换似乎失败了 - 您错过了对 <的显式调用代码>FROM_UNIXTIME:

You have the right idea, your conversion from the int literals you're using back to the timestamp seems off though - you're missing an explicit call to FROM_UNIXTIME:

UPDATE `ps_blog_post` 
SET `time_add` = 
     FROM_UNIXTIME(ROUND((RAND() * (1387888821 - 1357562421) + 1357562421)))

这篇关于sql在两个日期之间随机更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！