strtotime($query_result['timestamp'])

This will convert your MySQL timestamp value to the correct seconds since Jan 1, 1970 value. Then it's just a matter of subtracting the two to get the difference.

• How to calulate the difference between a MySQL timestamp and the current time in PHP

  I'm trying to calculate the difference between a timestamp retrieved from a MySQL database and the current time. Appreciate the help.

• How do I find the difference between a datetime type and the current date/time in php?

  I have a DATETIME for an entry in my database that is upcoming. I want to know the difference in time between the the DATETIME and the current date/time in Days, Hours, Minutes, and Seconds. I thoug…

• convert mysql timestamp into actual date and time?

  I have dates stored in a mysql table, they are set to store as CURRENT TIMESTAMP in each row and are stored as follows: 2010-05-29 01:17:35 but what i am trying to do is somehow use PHP to be…

• MySQL database + timestamp / PHP

  I have a variable in my database of type timestamp. Its default value is "CURRENT_TIMESTAMP" which is a great feature. However when I output the variable in the template it is formatted to an act…

• Removing rows from MySQL table where the timestamp is over one day old?

  I found the exact same question here . But it isn't working for me. I've modified it a bit, manipulated it, and I can't figure it out. I'm trying to remove rows that are over a day old. Here is m…

• MYSQL order by publish date and timestamp irregularities

  I'm trying to list out news using php and mysql based on the publish date and the time-stamp of the news article. I need all articles to list with the newest publish date and most recent time-stamp.…

• Making a PHP/MySQL Timestamp look more attractive

  So basically, I'm currently selecting a Timestamp from my MySQL database. In the database, the timestamp looks like so: 2010-06-30 12:36:08 Obviously for a webapp, that's not very attractive f…

• In mysql, how can I update timestamp type?

  Hi I have a table which have timestamp value, when I write that in php mysql_query("UPDATE table SET date=$newdate WHERE name=ibrahim"); it does not work. $newdate is a string value tha…

• Formating an SQL timestamp with PHP

  I have a mySQL database with a timestamp field. It currently only has one entry while I'm testing, it is 2010-02-20 13:14:09 I am pulling from the database and using echo date("m-d-Y",$r['…

• php/mysql - date_format and the time portion

  Apologies if this has already been answered many times, but I was unable to find the answer and I was flummoxed. I have a mysql query which seemingly outputs the result I want when I run it in th…