Community Member Profile
channa
Member since Aug 22, 2010
- Profile: /members/6717-channa.htm
- Comments: 1
- Points: 9
Recent Blog Comments By channa
-
Ask Ben: Getting A Random Date From A Date Range In SQL
Posted on Aug 22, 2010 at 5:59 AM
I did it like that random date betweem 1-9-2009 to 29-1-2010 (between 0 to 150 days) DECLARE @RandomNumber float DECLARE @RandomDayF int DECLARE @MaxDay int DECLARE @MinDay int SET @MaxDay = 150 SET @MinDay = 0 -- random the number of days to add
