If you want to retrieve rows with the correct month, regardless of year,
then you probably want the MONTH() function. It returns the month part of a
date as an integer from 1 to 12, so you could do
SELECT id, datecol, text FROM table
WHERE MONTH(datecol) = $mySelectedMonth;
Note, however, t
Is this what you're looking for?
SELECT id, datecol, text FROM table WHERE MONTH(datecol)
=$mySelectedMonth;
- Original Message -
From: "H Bartel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 11:34 AM
Subject: Select month from Date
> Hi,
>
> I am trying to st
