Get Date by Totaling All Seconds

Question:
How do I get the total number of seconds between two dates?

Answer:
You can use the DATEDIFF function to calculate the difference between two dates. The value can be returned in years, quarter, months, days, weeks, minutes, seconds and so on. This syntax returns the difference between today and yesterday in seconds:

SELECT DATEDIFF(ss, '06/29/00', '06/30/00') AS SecondsSeconds     ----------- 86400

Remember, if you’re using datetime variables or GETDATE() it will calculate using both the date and time stored in each variable.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: