Subject Re: [firebird-support] How to create random dates?
Author Ivan_P=c5=99enosil
Dne 31. 1. 2017 v 10:14 Köditz, Martin Martin.Koeditz@...
[firebird-support]:
> does anybody know an elegant statement to create random dates? It
> would be perfect to define a range.

select DATEADD(FLOOR(365*RAND()) DAY TO DATE'2016-1-1') from rdb$database;

RAND() returns DOUBLE PRECISION value between 0..1

I.