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|
. ;)
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 [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 12:58 PM
Subject: Re: date issue
: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
To: Daniel Rossi [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 12:58 PM
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
]
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
$_GET['month'] ,
You could use
(Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 6:59 AM
To: Daniel Rossi; [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
hi there i am having an issue formatting a date string back to mysql for a query, say
i 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'] , how can i format the month
sorry if you may get this twice, my work is persistant to not give me
newsgroup access and their email server is shitty and slow , i think being on
novell heh anyway here is the message.
hi there i am having an issue formatting a date string back to mysql for a
query, say i have a month string
PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Daniel Rossi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 1:41 AM
Subject: date issue