Date difference in SQL

Question

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

Thanks.

Answer 1

Use the TIMESTAMPDIFF function. (the TIMEDIFF function has a upper limit of 838:59:59)

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

Answer 2

Try this:

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

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