RE: date issue

2003-02-04 Thread Daniel Rossi
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

RE: date issue

2003-02-04 Thread Victor Pendleton
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

Re: date issue

2003-02-04 Thread Daniel Rossi
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,

Re: date issue

2003-02-04 Thread Kevin Smith
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" <

Re: date issue

2003-02-04 Thread Keith C. Ivey
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| > +---

Re: date issue

2003-02-03 Thread Stefan Hinz, iConnect \(Berlin\)
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