get a rand created time between 2012-10-1 and now.

[runeveryday]

i will use DATE_ADD,now if i want to get a rand time from 2012-10-1 to now,how should i do?

  created=DATE_ADD( DATE_ADD( DATE_ADD( DATE_ADD( DATE_ADD( DATE_ADD(
         NOW(), 
         INTERVAL 1 YEAR),
         INTERVAL 11*RAND() MONTH),
         INTERVAL 30*RAND() DAY),
         INTERVAL 23*RAND() HOUR),
         INTERVAL 59*RAND() MINUTE),
         INTERVAL 60*RAND() SECOND)

when i use the above code ,it get time isn't what i want. thank you.how to correct it?

eg: 30*RAND(3) what's the value will be?

[r937]

so you want a datetime, not a time, right?

[r937]

SELECT @secs := ROUND(RAND() * (UNIX_TIMESTAMP() - UNIX_TIMESTAMP('2012-10-01'))); 

SELECT '2012-10-01' + INTERVAL @secs SECOND;