RE: Another question of Date.

2002-04-11 Thread Basil Hussain
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

RE: Another question of Date.

2002-04-11 Thread Land, Christopher
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())) <

Re: Another question of Date.

2002-04-11 Thread Chuck \"PUP\" Payne
"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

Re: Another question of Date.

2002-04-11 Thread Chuck \"PUP\" Payne
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

RE: Another question of Date.

2002-04-11 Thread Roger Baklund
* 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 --

Re: Another question of Date.

2002-04-11 Thread Mike
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: > >

Re: Another question of Date.

2002-04-11 Thread Mike
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

Re: Another question of Date.

2002-04-11 Thread Chuck \"PUP\" Payne
FORMAT('1999-01-01', '%X %V'); > -> '1998 52' > > > Mike > - Original Message - > From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 7:42 AM >

Re: Another question of Date.

2002-04-11 Thread Mike
%S %w'); -> '22 22 10 10:23:00 PM 22:23:00 00 6' mysql> select DATE_FORMAT('1999-01-01', '%X %V'); -> '1998 52' Mike - Original Message - From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]> To: <[E

Another question of Date.

2002-04-11 Thread Chuck \"PUP\" Payne
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 t