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
Did you restart MySQL?
On 03/16/2007 02:22 PM, Ron Croonenberg wrote:
Hi quick question (off topic a bit)
MySQL seems to be not running on DST while the machine it is on is.
any ideas ?
if I use a mysql_query(select now(), connection); it looks like it is
an hour earlier then the system
Actually I did and that worked,
someone suggested that earlier in the thread
thanks for responding, I appreciate it
Ron
Micah Stevens wrote:
Did you restart MySQL?
On 03/16/2007 02:22 PM, Ron Croonenberg wrote:
Hi quick question (off topic a bit)
MySQL seems to be not running on DST
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
Hello,
Mr Frank is right. This is permission problem. I faced same problem
to run Oracle and MS Access in Windows 2003. Microsoft has changed user
privileges in Windows 2003. For example, I run a PHP program connect to
oracle in Windows XP but it isn't run in Windows 2003. When I
