Selecting columns from date1 and date2
CREATE TABLE Customer
(Start_date datetime2, End_date datetime2);
INSERT INTO Customer(Start_date, End_date)
VALUES ('2017-05-06 12:11:09', '2017-05-07 12:11:09');
Output
Query
SELECT DATEDIFF(day, Start_date, End_date)
FROM Customer;
Output
1
DATEDIFF() Function in SQL Server
DATEDIFF() function in SQL Server is used to find the difference between the two specified dates or times.
Features
- This function is used to find the difference between the two given date values.
- This function comes under Date Functions.
- This function can include time in the interval section and also in the date value section.
Syntax
DATEDIFF(datepart, Start_date, End_date);
Parameter
This method accepts three parameters as given below:
- datepart: It is the specified part that is to be returned. Moreover, the values of the interval can be given below.
datepart |
abbreviations |
---|---|
year |
yyyy,yy,y |
quarter |
qq,q |
dayofyear |
dy |
day |
dd,d |
week |
ww,wk |
weekday |
dw,w |
hour |
hh |
minute |
mi,n |
second |
ss,s |
millisecond |
ms |
- Start_date: The starting date of the interval.
- End_date: The ending date of the interval.
Return Type of DATEDIFF() is: int
Return Value: It returns the difference between the two specified dates.