Presenting a Past Time in Hours, Minutes and Seconds in MySQL

Q

How To Present a Past Time in Hours, Minutes and Seconds in MySQL?

✍: FYIcenter.com

A

If you want show an article was posted "n hours n minutes and n seconds ago", you can use the TIMEDIFF(NOW(), pastTime) function as shown in the following tutorial exercise:

SELECT TIMEDIFF(NOW(), '2006-07-01 04:09:49') FROM DUAL; 
   06:42:58

SELECT TIME_FORMAT(TIMEDIFF(NOW(), '2006-06-30 04:09:49'),
   '%H hours, %i minutes and %s seconds ago.') FROM DUAL;
   30 hours, 45 minutes and 22 seconds ago.

 

Extract Unit Values from a Date and Time in MySQL

Calculating the Difference between Two Time Values in MySQL

Introduction to Date and Time Handling in MySQL

⇑⇑ MySQL Database Tutorials

2017-12-26, 2680🔥, 0💬