Answers for "sql random date between two dates"

SQL
0

sql random date between two dates

declare @FromDate date = '2011-01-01'
declare @ToDate date = '2011-12-31'

select dateadd(day, 
               rand(checksum(newid()))*(1+datediff(day, @FromDate, @ToDate)), 
               @FromDate)
Posted by: Guest on March-30-2022

Code answers related to "sql random date between two dates"

Code answers related to "SQL"

Browse Popular Code Answers by Language