select date_format(datefield,'%M') as theDate from table [where clause]
Bastien
From: Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx>
Reply-To: ron.php@xxxxxxxxxxxxxxxxxx
To: PHP DB <php-db@xxxxxxxxxxxxx>
Subject: 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
