Re: [firebird-support] How to create random dates?

2017-01-31 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
That's it. Thank you Ivan.

Re: [firebird-support] How to create random dates?

2017-01-31 Thread Ivan Přenosil ivan.preno...@seznam.cz [firebird-support]
Dne 31. 1. 2017 v 10:14 Köditz, Martin martin.koed...@it-syn.de [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

[firebird-support] How to create random dates?

2017-01-31 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Hi, does anybody know an elegant statement to create random dates? It would be perfect to define a range. Regards Martin