Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Aug 22, 2010

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 SELECT @RandomNumber = RAND() set @randomDayF = ... read more »