SQL date difference

Question

How can I get the number of seconds between NOW () and the date in the database.

Thank.

Answer 1

Use the function TIMESTAMPDIFF. (function TIMEDIFFhas an upper limit 838:59:59)

SELECT TIMESTAMPDIFF(SECOND, DateColumn, NOW()) As Seconds
FROM table

Answer 2

Try the following:

SELECT TIME_TO_SEC(TIMEDIFF(Now(), yourDateTime)) From Table;

• MySQL: Now ()
• MySQL: TimeDiff Function
• MySQL: TIME_TO_SEC Function