brownbrod Posted June 19, 2014 Share Posted June 19, 2014 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! Link to comment https://forums.phpfreaks.com/topic/289207-timestamp-help/ Share on other sites More sharing options...
Ch0cu3r Posted June 19, 2014 Share Posted June 19, 2014 Use the MySQL NOW() function explicitly in your query. Link to comment https://forums.phpfreaks.com/topic/289207-timestamp-help/#findComment-1482897 Share on other sites More sharing options...
ginerjm Posted June 19, 2014 Share Posted June 19, 2014 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. Link to comment https://forums.phpfreaks.com/topic/289207-timestamp-help/#findComment-1482902 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.