Sorry, Do you mean to use the date in a WHERE clause? I've use php's 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 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 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', > > '%D %y %a %d %m %b %j'); > > -> '4th 97 Sat 04 10 Oct 277' > > mysql> select DATE_FORMAT('1997-10-04 22:23:00', > > '%H %k %I %r %T %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: <[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 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 that I > >> can see how old a person is. Is there any example on the net of this? > >> > >> Chuck > >> > >> Sql and MySql > >> > >> > >> --------------------------------------------------------------------- > >> Before posting, please check: > >> http://www.mysql.com/manual.php (the manual) > >> http://lists.mysql.com/ (the list archive) > >> > >> To request this thread, e-mail <[EMAIL PROTECTED]> > >> To unsubscribe, e-mail <[EMAIL PROTECTED]> > >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php