网络营销电子商务研究中心 - Update random dates in MYSQL table

网络营销电子商务研究中心 (https://www.0058.net/index.php)

- MySQL (https://www.0058.net/forumdisplay.php?f=76)

- - Update random dates in MYSQL table (https://www.0058.net/showthread.php?t=5095)

Inger

2015-04-19 06:35 AM

Update random dates in MYSQL table

UPDATE randomdate SET randomdate= DATE_SUB(CURDATE(),INTERVAL RAND()*365 DAY);

All times are GMT +8. The time now is 12:26 AM.