Date difference

[Kratik]

How can I get the number of seconds between NOW() and also a date in the database? I am following this article here to get a better idea about the concept of the date difference in SQL but am unable to understand it in a good way can someone here please guide me?

Thanks in advance!

[Wissam]

Hello, Kratik,

The DATEDIFF takes 3 parameters:

- first, the `datepart` which is the part of the date you want as a result. In your case, it should be `second`

- the next two parameters are the `startdate` and `enddate`. The start date should be the date from your database, and `enddate` should be the function GETDATE.

The query will calculate the difference between both dates, and return the chosen `datepart` from it.

Here is what your query should look like:

SELECT DATEDIFF ( second , 'date from your database' , GETDATE() )

 

Note that, GETDATE was used instead of NOW. The Now function is specific to MYSQL, and getting the date difference is different in MYSQL, where TIMESTAMPDIFF is used instead of DATEDIFF.

For more information, please refer to these articles:

https://learn.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver16

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_timestampdiff

 

Regards,
Wissam
Progress Telerik