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 year so
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.
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
question of Date.
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
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
: 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())) =7 AND (TO_DAYS(D\
OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null
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
10 matches
Mail list logo