Update random dates

Submitted by:David Villa

Date added:29 July, 2013

Category:MySQL

Update random dates in MYSQL table

Tags: random dates , update dates

Code Snippet:

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

Comments