http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October
SELECT DATE_FORMAT(date column,'%W %M %Y') as date FROM table;
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want to be able
AM
Subject: Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql select DATE_FORMAT('1997-10-04 22
* Chuck PUP Payne
Thanks but I want to be able able to use this in SQL statement not format
the output.
SELECT *
FROM
table
WHERE
DATE_FORMAT(birthday,'%M %D') = DATE_FORMAT(now(),'%M %D');
--
Roger
query
-
PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/D
date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want
]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http
Hi,
I got a small problem I like to be able to read a DATE but I don't want to
read the Year. I only want to read the month and the date. For example, I
like to read the a Birthday Field to see who Bithday is today.
Also like to
be later be able to read that same field but this time the