List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 21 2001 2:14am
Subject:Re: Select partial DATE?
View as plain text  
At 9:55 PM -0400 4/20/01, Jason Lam wrote:
>Hello!
>
>Let's say I have a DATE field and in the dataset, I got some dates such as
>
>2000-01-01
>2001-02-01
>2001-02-05
>2001-02-06
>
>How would I be able to just select all the 2001-02 entries? 
>Obviously, the month  and the year are the same, but the date is 
>not, is there a mysql function to do this?
>
>In a nutshell, how do I select some DATE type of data just by year 
>and month match?
>
>Thanks
>
>Jason Lam

WHERE YEAR(date) = 2001 AND MONTH(date) = 2

-- 
Paul DuBois, paul@stripped
Thread
Select partial DATE?Jason Lam21 Apr
  • Re: Select partial DATE?Paul DuBois21 Apr