Collections:
Presenting a Past Time in Hours, Minutes and Seconds in MySQL
How To Present a Past Time in Hours, Minutes and Seconds in MySQL?
✍: FYIcenter.com
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
2017-12-26, 1778👍, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...