RE: [PHP-DB] Values in a date field

[Bastien Koert]

select date_format(datefield,'%M') as theDate from table [where clause]
Bastien




From: Ron Piggott <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: PHP DB <php-db@lists.php.net>
Subject: [PHP-DB] Values in a date field
Date: Sat, 17 Mar 2007 09:44:43 -0400


I have a $subscription_begins variable.  It the date type.  YYYY-MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron


_________________________________________________________________
Don’t waste time standing in line—try shopping online. Visit Sympatico / MSN 
Shopping today! http://shopping.sympatico.msn.ca

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php