RE: SQL RAND function question

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

I don't see anything wrong that jumps out at me, so I'll ask some questions.

Why are you using a seed value?
What are you counting and does the sum of individual counts add up to the
total count?

I might rewrite that line as:

myDate = date('2008-03-01')   + INT(rand() * 12)  months

but I don't think that'll have any effect on the counts you're seeing.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com
 

-----Original Message-----
Subject: SQL RAND function question

All,

I'm attempting to use SQL's RAND() function to randomly assign a number from
0-11.  Actually, the 0-11
is used as a number of months to add to 2008-03-01.

Looking at a count of the results however seems to indicate I'm doing
something wrong:

Date                       count(*)

2008-03-01              13,234
2008-04-01               6,536
2008-05-01              13,262
2008-06-01              13,153
2008-07-01              13,474
2008-08-01              13,448
2008-09-01              13,245
2008-10-01              13,329
2008-11-01              13,358
2008-12-01              13,307
2009-01-01              13,542
2009-02-01               6,636

I'm thinking perhaps the way I'm going from the RAND() results to a integer
from 0-11 is the problem.
Anybody understand what I'm doing wrong?

myDate = date('2008-03-01')   + cast(round((rand(12) * 11),0) as int)
months

Thanks!

Charles Wilt