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 > --------------------------------------------------------------------- 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