devxlogo

Get Date by Totaling All Seconds

Why Trust Us

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.

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Five Early Architecture Decisions That Quietly Get Expensive
Disclosure

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

Show More