RE: [PHP-DB] Values in a date field
| From: | Bastien Koert | Date: | Sat, 17 Mar 2007 14:35:31 +0000 |
| Subject: | RE: [PHP-DB] Values in a date field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43298@lists.php.net to get a copy of this message | ||
select date_format(datefield,'%M') as theDate from table [where clause]
Bastien
From: Ron Piggott <ron.php@actsministries.org> Reply-To: ron.php@actsministries.org 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_________________________________________________________________ Dont waste time standing in linetry shopping online. Visit Sympatico / MSN Shopping today! http://shopping.sympatico.msn.ca