Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @RandomDate datetime
- DECLARE @fromDate datetime='2018-04-07'
- SELECT @RandomDate= (DATEADD(day, ROUND(DATEDIFF(day, @fromDate, @fromDate)
- * RAND(CHECKSUM(NEWID())), 5),DATEADD(second, CHECKSUM(NEWID()) % 12000,
- @fromDate)))
- SELECT @RandomDate
Add Comment
Please, Sign In to add comment