tableName
WHERE DATE_FORMAT(columnName, '%M') = 'January';
Regards,
Victor Pendleton
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 6:59 AM
To: Daniel Rossi; [EMAIL PROTECTED]
Subject: Re: date issu
si; [EMAIL PROTECTED]
Subject: Re: date issue
Daniel,
(you posted this question twice, but I will only answer it once ;-)
> have a month string January from a get query string like so
?month=January ,
> and i need >to check a range of results within an endate so i need
WHERE end_date
ou can do a range of months, though you could use the IN clause
with the WHERE clause.
- Original Message -
From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
To: "Daniel Rossi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 03,
ary'
LIMIT 1;
And provided the month is indeed February. ;)
Not sure if you can do a range of months, though you could use the IN clause
with the WHERE clause.
- Original Message -
From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
To: "Daniel Rossi" <
On 3 Feb 2003, at 13:58, Stefan Hinz, iConnect (Berlin wrote:
> You could use the DATE_FORMAT() function of MySQL for this:
>
> mysql> SELECT DATE_FORMAT(NOW(),'%M');
> +-+
> | DATE_FORMAT(NOW(),'%M') |
> +-+
> | February|
> +---
Daniel,
(you posted this question twice, but I will only answer it once ;-)
> have a month string January from a get query string like so
?month=January ,
> and i need >to check a range of results within an endate so i need
WHERE end_date
> $_GET['month'] ,
You could use the DATE_FORMAT() functi