Subject | Re: [firebird-support] How to create random dates? |
---|---|
Author | Ivan_P=c5=99enosil |
Post date | 2017-01-31T09:42:39Z |
Dne 31. 1. 2017 v 10:14 Köditz, Martin Martin.Koeditz@...
[firebird-support]:
RAND() returns DOUBLE PRECISION value between 0..1
I.
[firebird-support]:
> does anybody know an elegant statement to create random dates? Itselect DATEADD(FLOOR(365*RAND()) DAY TO DATE'2016-1-1') from rdb$database;
> would be perfect to define a range.
RAND() returns DOUBLE PRECISION value between 0..1
I.