Random dates in MYSQL table

Submitted by:Jhon Jhon

Date added:22 December, 2012

Category:MySQL

How to update random dates in MYSQL table

Tags: random dates

Code Snippet:

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

Comments