DaniWeb Forum Index > Web Development > PHP

PHP Date always returns 0

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Sep 2008

Posts: 6

Reputation: pocnib is an unknown quantity at this point

Solved Threads: 0

pocnib

Offline

Newbie Poster

PHP Date always returns 0

Dec 4th, 2008

I am trying to insert a date into a mysql table field using

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
$date=date(Y-m-d);
mysql_query("INSERT INTO table VALUES('$date')");
?>
<?php
$date=date(Y-m-d);
mysql_query("INSERT INTO table VALUES('$date')");
?>

but when I open up mysql and run SELECT * FROM table; it returns a date value of 0000-00-00 instead of the current date at time of insert. Am I misunderstanding something with the php date function?

•

Join Date: Sep 2008

Posts: 6

Reputation: pocnib is an unknown quantity at this point

Solved Threads: 0

pocnib

Offline

Newbie Poster

Re: PHP Date always returns 0

Dec 4th, 2008

It was quotes around the date format string. Why does the obvious always become obvious only after you ask for help?

•

Join Date: Apr 2008

Posts: 75

Reputation: danishbacker is an unknown quantity at this point

Solved Threads: 5

danishbacker danishbacker is offline

Offline

Junior Poster in Training

Re: PHP Date always returns 0

Dec 15th, 2008

i think you have to use
date_default_timezone_set('yourtime zone');
for me it is as follows
date_default_timezone_set('Asia/Calcutta');
then call date();

www.peipians.com
bizarreinnovations.com