List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 2 1999 12:30am
Subject:Re: Time and date question.
View as plain text  
At 7:26 PM -0500 9/1/99, Z Mehta wrote:
>I am trying to select all entries which were input during a selected
>month.
>
>Something like this:
>SELECT * FROM Customer where Date= Month(06);
>
> So customer is my table and 'date' is a timestamp column.  So in the
>above example I want all entries submitted in June.  I looked in the
>manual but it wasn't clear.

What were you looking at that wasn't clear?

Also, try this instead:

	where MONTH(Date) = 6


--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Time and date question.Z Mehta2 Sep
  • Re: Time and date question.Paul DuBois2 Sep
  • Re: Time and date question.Scott Hess2 Sep