Getting the Number of Days Between Two Dates in SQL Server

In SQL Server, you can calculate the number of days between two dates using the `DATEDIFF` function. Here's how to do it.

Syntax

The syntax to get the number of days between two dates is as follows:

SELECT DATEDIFF(day, @startDate, @endDate) AS DaysBetween; 

This query returns the number of days between the `@startDate` and `@endDate` variables.

Example

Let's say we want to calculate the number of days between '2023-03-01' and '2023-03-15':

DECLARE @startDate DATE = '2023-03-01'; DECLARE @endDate DATE = '2023-03-15'; SELECT DATEDIFF(day, @startDate, @endDate) AS DaysBetween; 

This query will return the result:

The result shows that there are 14 days between '2023-03-01' and '2023-03-15'.

Using a Table Column

If you want to calculate the number of days between two dates in a table column, you can use the following syntax:

SELECT DATEDIFF(day, StartDate, EndDate) AS DaysBetween FROM YourTableName; 

This query will return the number of days between the `StartDate` and `EndDate` columns for each row in the table.

Example Output

The output of the query will be a list of the number of days between the start and end dates for each row. Here's an example output:

In this example, the output includes the number of days between the start and end dates for each row in the table.