Subject Re: [firebird-support] select birthdays from the next several days
Author Christian Brümmer
Hi Magnus,

Magnus Titho wrote:

> select Birthday
> from Persons
> where cast('2000-' || extract(month from Birthday) || '-' || extract(day
> from Birthday) as date) between [...]

This is close to my idea 2, but as a single SQL. Thank you very much,
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