How can I get difference of two dates through MYSQL select query

H开发者_如何学编程ow can I get difference of two dates (up to seconds precision) through MYSQL select query.

Can some one guide me in this regards.

---

Returns the difference in seconds between two dates.

SELECT TIME_TO_SEC(TIMEDIFF('2007-01-09 10:24:46','2007-01-09 10:23:46'));

---

You can use DATEDIFF() or TIMEDIFF()

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html