Update a datetime variable in mysql

Question

I'm trying to update my MySQL database with a DateTime variable.

$interval = 'P' . $days . 'DT' . $hours. 'H' . $minutes. 'M' . $seconds . 'S'  ;
$date = new DateTime("NOW");
$date->add(new DateInterval($interval));

Now the SQL update:

$query = "UPDATE table
SET table.table_date = '$date' ";
mysql_query($query);
mysql_query($query);

If I var_dump the $date variable, it shows the right properties:

object(DateTime)#4 (3) { ["date"]=> string(19) "2012-07-05 20:04:14" ["timezone_type"]=> int(3) ["timezone"]=> string(13) "Europe/Berlin" }

but it just wont be inserted. If I try NOW() instead of $date, it works perfectly. Whats my mistake?

You should use PDO or MySQLi instead of the mysql_ extensions, whose use is discourage and which will probably be removed from PHP soon. Using prepared statements should also solve this problem. — Ry-
– Ry- ♦, Commented Jul 5, 2012 at 18:13

gen_Eric · Accepted Answer · 2012-07-05 18:19:32Z

3

Try this:

"UPDATE table SET table.table_date = '{$date->format('Y-m-d H:i:s')}'"

edited Jul 5, 2012 at 18:19

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

answered Jul 5, 2012 at 18:17

Ron

1,32613 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zane Bien · Accepted Answer · 2012-07-05 18:22:21Z

3

It's not working because you are trying to insert an object directly into a string. What you need to do is convert the object to a usable datetime string first:

$futuredate = $date->format('Y-m-d H:i:s');
$query = "UPDATE table SET table.table_date = '$futuredate'";

answered Jul 5, 2012 at 18:22

Zane Bien

23.2k6 gold badges47 silver badges58 bronze badges

Collectives™ on Stack Overflow

Update a datetime variable in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related