HowTo: Random DATE in MySQL
select str_to_date(
concat(
floor(1 + rand() * (12-1)),
'-',
floor(1 + rand() * (28 -1)),
'-',
'2009'),
'%m-%d-%Y');
concat(
floor(1 + rand() * (12-1)),
'-',
floor(1 + rand() * (28 -1)),
'-',
'2009'),
'%m-%d-%Y');
Comments
Write the first comment
Leave a trace
Post being viewed right now
