How to get seconds between two dates in SQL Server?

Question

I had this MySQL code

DELETE FROM UserError WHERE UNIX_TIMESTAMP() - UNIX_TIMESTAMP(date) > 86400

What is equivalent of this MySQL code in SQL Server?

In MSSQL, you need to use DATEDIFF function. Check this link: http://stackoverflow.com/questions/13577898/sql-time-difference-between-two-dates-result-in-hhmmss — Paresh J, Nov 20 '14 at 05:02

score 43 · Accepted Answer · answered Nov 20 '14 at 05:04

43

You can use datediff

DELETE FROM UserError WHERE 
Datediff(s, [date], getdate()) > 86400

answered Nov 20 '14 at 05:04

radar

4

Plus one for the example that shows `GETDATE()` and not just `DATEDIFF`, which is part of what OP needs. – ta.speot.is Nov 20 '14 at 05:05

score 5 · Answer 2 · answered Nov 20 '14 at 05:04

5

Try this:

SELECT DATEDIFF(second, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000'); 

--Syntax
       DATEDIFF ( datepart , startdate , enddate )

answered Nov 20 '14 at 05:04

Dhwani

score 3 · Answer 3 · answered Nov 20 '14 at 05:02

3

You can make use of DateDiff for this. It looks like this:

DateDiff(datePart,startDate,endDate)

answered Nov 20 '14 at 05:02

danish

score 1 · Answer 4 · answered Nov 20 '14 at 05:03

1

DATEDIFF ( ss , startdate , enddate )

answered Nov 20 '14 at 05:03

Krish KvR

4 Answers4