View Single Post

  #2 (permalink)  
Old 04-22-2007
Paul Lautman
 
Posts: n/a
Default Re: URGENT HELP NEEDED PLEASE! Selecting a date range without the year

macca wrote:
> Hi,
> I need to be able to select a range of dates between cretain months
> and days but without the year,
>
> Something like :
>
> SELECT foobar FROM footable WHERE dates BETWEEN start_date_month_day
> AND end_date_month_day
>
>
> That will return all the results between those months and days
> regardless of the year.
>
>
> Any help would be appreciated.
>
> Thanks, paul.


Can the dates span year boundaries?


Reply With Quote