Subject | Re[2]: [firebird-support] select birthdays form the next several days |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-09-23T12:13:02Z |
Hello Christian,
CB> This cannot work, as most of the people don't have birthday in the same
CB> year. I can use this with my second idea (with a second column with a
CB> fixed year) but not on the original dates.
:) Sorry, I need to sleep more :)
Then create another field with 'mmdd' as John suggested, [index
it,] and use trigger(s) to populate it. (it's my prefer :)
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com/
CB> This cannot work, as most of the people don't have birthday in the same
CB> year. I can use this with my second idea (with a second column with a
CB> fixed year) but not on the original dates.
:) Sorry, I need to sleep more :)
Then create another field with 'mmdd' as John suggested, [index
it,] and use trigger(s) to populate it. (it's my prefer :)
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com/