"Carolyn Marenger" <cajunk@marenger.com> schreef in bericht
news:c700e$47a08217$cf70133e$13696@PRIMUS.CA...
> Luuk wrote:
>> "Carolyn Marenger" <cajunk@marenger.com> schreef in bericht
>> news:44b9a$47a078eb$cf70133e$2109@PRIMUS.CA...
>>> Kim wrote:
>>>> On Jan 29, 11:31 pm, Carolyn Marenger <caj...@marenger.com> wrote:
>>>>> How do I perform a select statement that would locate all records in
>>>>> which the day and month are in the next say 30 days regardless of the
>>>>> year. Basically an upcoming birthday/anniversary list.
>>>>>
>>>>> Thanks, Carolyn
>>>> Have a look at the function date_sub(), and you find more date
>>>> functions here
>>>> http://dev.mysql.com/doc/refman/5.1/...functions.html.
>>> I don't think I can use date_sub() for it, but extract looks like it a
>>> close match to my needs.
>>>
>>> Carolyn
>>
>> select now(), date_add(now(), INTERVAL 30 DAY);
>> or
>> select now(), date_sub(now(), INTERVAL -30 DAY);
>>
>> gives:
>> 2008-01-30 14:38:29 2008-02-29 14:38:29
>>
>>
>> i think this will be easier than the extract function ?
>>
>
> That gives me dates for this year, but I want to get a listing of all
> people with birthdays in the next 30 days. So, today being January 30th,
> I want a listing of all people with birthdays from today, 01-30 to 03-02
> for ALL years, not just the current year.
>
> As I understood date_add(), it would only give me people born today and in
> the next 30 days. Am I mistaken?

you're right... i did not read your question correctly...