| Subject | RE: [firebird-support] select birthdays form the next several days |
|---|---|
| Author | Simon Carter |
| Post date | 2005-09-23T08:43:33Z |
> -----Original Message-----If you use this approach, you might want to check out this link
> 1st idea: in my application, I will calculate the days and
> split it into months and days. In the SQL statement, I will
> filter the information with WHERE to check the months and days.
(http://www.fbtalk.net/viewtopic.php?id=189) which has some stored procs for
encoding/decoding date and times, as well as a datediff stored procedure.
Rgds
Si Carter
http://www.fbtalk.net/
http://www.tectsoft.net/