As mentioned by @RemoteSojourner, I got the current time in a UNIX timestamp format (which returns time in seconds), I got the timestamp from the DB (using an ORM) and converted that to a UNIX timstamp too and then subtracted the two timestamps.

            $current_time = strtotime("now");
            $last_access_time = strtotime($this->last_access);
            $inactivity_duration = $current_time - $last_access_time;

• How do I get the difference between a mysql timestamp and the php current time?

  The question i guess is kind of 2 questions: How do i even GET the current time in php and in a format that is easily compared to and Once i have that, i have a mysql timestamp in this format…

• 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…

• How to combine two rows and calculate the time difference between two timestamp values in MySQL?

  I have a situation that I'm sure is quite common and it's really bothering me that I can't figure out how to do it or what to search for to find a relevant example/solution. I'm relatively new to My…

• What is the difference between the current timestamp in the GMT time zone and the current timestamp in your local time zone?

  This is a sample question i found at ZEND php certificate practice test, the correct answer of this question is: " There is no difference between the current time in any time zone—the current time i…

• how to insert the current timestamp into mysql db using a php insert query

  In my database (mysql), i have a table with structure - username - varchar insert_time - timestamp this table was created in mysql using the phpmyadmin tool, and for the insert_time column, i hav…

• what is the difference betwen timestamp in java and php?

  I have a java file that write records to the DB and time stamps I have another php file that reads that records.. unfortunately After converting the time stamp to dates I got a wrong dates ?? …

• Current timestamp in PHP and MySQL

  I am using PHP to print the current timestamp using time() and I have a MySQL column which stores the date, which I am converting to a timestamp using strtotime() . However, when I print the convert…

• Extract the Day / Month / Year from a Timestamp on MYSQL

  I have : $date = $actualite['date']; $actualite['date'] is a TIMESTAMP and i was wondering how i can extract from this timestamp the day, then the month, then the year in 3 variables. T…

• Should I use a timestamp or text field in MySQl for UTC time/date

  I read a mysql timestamp can only hold a value from 19700101000000 to sometime in the year 2037. I seriously doubt my app will be around then, well i'm sure it wont but any idea what will people use…

• Use PHP to truncate the age of a MySQL entry to the nearest unit of time

  I have a table with a datetime field, and I want to pull that time stamp and use PHP to convert it to the nearest largest unit of time. For example, if the entry was made 2 minutes and 36 seconds ag…