View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 10:32 AM
Kim
 
Posts: n/a
Default Re: pulling upcoming dates

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.
Reply With Quote