Timestamp help

[brownbrod]

I have a update query that should be updating the timestamp when a "month" field is changed.    I have the following code:

 

$month_update->bindParam(':timestamp', strtotime (date("Y-m-d H:i:s")), PDO::PARAM_INT);

 

The result that is returned is 1403198033.  I need it to look like this 2014-03-26 07:09:06.    I know I am missing something and I would greatly appreciate your help.

 

Thank you so much!

 

[Ch0cu3r]

Use the MySQL NOW() function explicitly in your query.

[ginerjm]

Or simply don't use the strtotime function call. Date() is providing you what you want but then you go and turn it back into an integer. BTW - the result of date() is not an integer.