Subject Re: [firebird-support] select birthdays form the next several days
Author Pavel Menshchikov
Hello Christian,

CB> I have a table with the name as varchar and the birthday as date.

CB> And now a simple question: how can a get with a simple SQL statement the
CB> name of the people, who will have birthday within the next 14 (for
CB> example) days. Is it possible to do this in a single SQL statement?

CB> The question is easy, but the solution not, correct?

Have you tried
select Name, BirthDate from Persons
where BirthDate between :Dt and :Dt + 14;

Best regards,
Pavel Menshchikov