<div>
<div class="content wysiwyg-content">
What is the proper SQL syntax for getting the difference between two dates, and returning the result in seconds?<br />
<br />
Specifically I am confused why the following syntax<br />
<br />
SELECT TIME_TO_SEC( DATEDIFF( NOW( ) , SUBDATE( NOW( ) , INTERVAL 1 DAY ) ) )<br />
<br />
returns 1, when that is the number of days and not the number of seconds in the date difference. <br />

</div>
</div>


What is the proper SQL syntax for getting the difference between two dates, and returning the result in seconds?

Specifically I am confused why the following syntax

SELECT TIME_TO_SEC( DATEDIFF( NOW( ) , SUBDATE( NOW( ) , INTERVAL 1 DAY ) ) )

returns 1, when that is the number of days and not the number of seconds in the date difference. 


Why does TIME_TO_SEC not convert time to seconds in the following statement?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.