Martin Köditz wrote:
Does anybody know an elegant statement to create random dates?
Ivan Přenosil answers:
select DATEADD(FLOOR(365*RAND()) DAY TO DATE'2016-1-1') from rdb$database;
RAND() returns DOUBLE PRECISION value between 0..1
Does anybody know an elegant statement to create random dates?
select DATEADD(FLOOR(365*RAND()) DAY TO DATE'2016-1-1') from rdb$database;
RAND() returns DOUBLE PRECISION value between 0..1