Re: [SQL] Birthday search.

2001-03-22 Thread Jason Earl
Here's an example of something that works with some of the data that I have lying around. Replace exit_dt with "birthday" (or whatever you have named the field that holds the birthday information) and replace ticket_no with name (or whatever) and you should be on the right track. SELECT exit_dt,

[SQL] Birthday search.

2001-03-22 Thread Antti Linno
I have a table with personal data, including date of birth in date format. What i need is a select that searches birthdays in certain range. E.g. I need to find all birthdays starting from 15.april until 20th december. As you all understand, year doesn't matter :P Any simple and elegant solutions