For testing an algorithm I would like to generate 10,000 random birthdates from 01/01/1995 to 31/12/2013. Can this be done in SQL and how?
Thank you in advance
Asked
Active
Viewed 178 times
-1
-
3Probably. Did you have a particular RDBMS in mind? – Matt Gibson May 09 '14 at 13:35
-
Check this out: http://stackoverflow.com/questions/794637/how-to-update-rows-with-a-random-date – Dunken May 09 '14 at 13:35
-
Use any random number generator you happen to have handy to generate numbers between 0 and 6939. Then add that number of days onto `1995-01-01`. – Damien_The_Unbeliever May 09 '14 at 13:42
1 Answers
0
To generate a random date:
select cast(cast(RAND()*100000 as int) as datetime)
You can then write code around this statement to limit it to a range.
BigBlue
- 66
- 2
-
See the remark by Damien - if you use 6939 as multiplier, you don't have to add extra code to limit the range. – Hans Kesting May 09 '14 at 13:58
-
Well, 6940 since you want numbers >=0 and < 6940 which is what multiplying `RAND()` by 6940 will produce. – Damien_The_Unbeliever May 09 '14 at 14:09