I want to retrieve a time from Mysql table and want to get it's difference with current time time.
To be More clear :
[Current_Time]-[Time retrieved from SQL TABLE] = HH:MM:SS
Asked
Active
Viewed 63 times
-3
-
2Possible duplicate of [How to get time difference in minutes in PHP](http://stackoverflow.com/questions/365191/how-to-get-time-difference-in-minutes-in-php) – Nizarii Jun 12 '16 at 16:02
-
[The MySQL answer](http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html) – AgRizzo Jun 12 '16 at 16:03
-
1and you've tried what exactly? – Funk Forty Niner Jun 12 '16 at 16:04
1 Answers
0
You can do the calculation in the database. For instance, if the "time column" is stored as datetime:
select timediff(now(), t.timecol)
from table
If the timecol is stored as a time data type, then use:
select timediff(curtime(), t.timecol)
from table
Gordon Linoff
- 1,242,037
- 58
- 646
- 786