and the order of the startdate and enddate parameters matters. Therefore, if you swap the order, the result will have the opposite sign. Here’s an example of calculating the difference between two dates in hours:
Here's an example SQL query that calculates the number of days between the "start_date" and "end_date" in a table named "events": SELECT event_name, start_date, end_date, DATEDIFF(DAY, start_date, end_date) AS duration_in_days FROM events; Example table response The example query ...
This example calculates the number of day boundaries crossed between dates in two columns in a table. SQL CREATETABLEdbo.Duration (startDate datetime2, endDate datetime2);INSERTINTOdbo.Duration (startDate, endDate)VALUES('2007-05-06 12:10:09','2007-05-07 12:10:09');SELECTTOP(1)DATEDIFF...
This example calculates the number of day boundaries crossed between dates in two columns in a table. SQL CREATETABLEdbo.Duration ( startDate DATETIME2, endDate DATETIME2 );INSERTINTOdbo.Duration (startDate, end
This example calculates the number of day boundaries crossed between dates in two columns in a table. SQL Copy CREATE TABLE dbo.Duration ( startDate DATETIME2, endDate DATETIME2 ); INSERT INTO dbo.Duration (startDate, endDate) VALUES ('2007-05-06 12:10:09', '2007-05-07 12:10:09'...
This example calculates the number of day boundaries crossed between dates in two columns in a table. SQL Copy CREATE TABLE dbo.Duration ( startDate DATETIME2, endDate DATETIME2 ); INSERT INTO dbo.Duration (startDate, endDate) VALUES ('2007-05-06 12:10:09', '2007-05-07 12:10:09'...
ExampleGet your own SQL Server Return the difference between two date values, in years: SELECTDATEDIFF(year,'2017/08/25','2011/08/25')ASDateDiff; Try it Yourself » Definition and Usage The DATEDIFF() function returns the difference between two dates, as an integer. ...
Example: You want to calculate the delivery time, which is the difference between the order date and the receiving date, in days: The syntax would be: DATEDIFF(day, order_date, receiving_date) The full demo SQL statement: SELECT order_date, receiving_date, DATEDIFF(day, order_date, recei...
This example uses different types of expressions as arguments for the startdate and enddate parameters. It calculates the number of day boundaries crossed between dates in two columns of a table. SQL Copy CREATE TABLE dbo.Duration (startDate datetime2, endDate datetime2); INSERT INTO dbo....
SELECT DATEDIFF(day,'2008-06-05','2008-08-05') AS DiffDate Result: 61 Example Now we want to get the number of days between two dates (notice that the second date is "earlier" than the first date, and will result in a negative number). ...