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
t: Thursday, April 11, 2002 5:10 AM
To: Mike; [EMAIL PROTECTED]
Subject: Re: Another question of Date.
Mike and the mysql list,
This is the SQL statement I am using now;
SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) <
"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
uot;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 able to use t
* 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
--
D]>; <[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:
>
>
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
Su
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 Oc
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',
