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/
