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:
>Let's say I have a DATE field and in the dataset, I got some dates such as
>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?
>Jason Lam

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

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