sry.. just check the script.. if able.. plz info me
- Original Message -
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Cc: [EMAIL PROTECTED]
Sent: Sunday, March 18, 2007 8:38 AM
Subject: Re: [PHP-DB] Values in a date field
Assuming you're using MySQL, try MONTH(). As in:
SELECT
I have a $subscription_begins variable. It the date type. -MM-DD
How may I find out the month value (1 to 12) of this variable?
Ron
$date=Getdate($subsciption_begins);
$month=$date[mon]
-邮件原件-
发件人: Ron Piggott [mailto:[EMAIL PROTECTED]
发送时间: 2007年3月17日 21:45
收件人: PHP DB
主题: [PHP-DB] Values in a date field
I have a $subscription_begins variable. It the date type. -MM-DD
How may I find out the month value (1
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
Assuming you're using MySQL, try MONTH(). As in:
SELECT MONTH(SomeDateField) FROM SomeTable
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
If this isn't a database question, but a general PHP question, try this:
// For numeric month without leading zero, use n
echo