Subject | Re: [firebird-support] select birthdays from the next several days |
---|---|
Author | Christian Brümmer |
Post date | 2005-09-23T09:02:15Z |
Hi Magnus,
Magnus Titho wrote:
this is exactly, what I was looking for.
In general I should play around more with the CAST function.
Hi Simon,
Simon Carter wrote,
for. But in general this is a good link to other sources.
Thanks again to both of you for your fast reply.
Christian
Magnus Titho wrote:
> select BirthdayThis is close to my idea 2, but as a single SQL. Thank you very much,
> from Persons
> where cast('2000-' || extract(month from Birthday) || '-' || extract(day
> from Birthday) as date) between [...]
this is exactly, what I was looking for.
In general I should play around more with the CAST function.
Hi Simon,
Simon Carter wrote,
> (http://www.fbtalk.net/viewtopic.php?id=189)thanks for your link, but even the datediff is not, what I was looking
for. But in general this is a good link to other sources.
Thanks again to both of you for your fast reply.
Christian