Selecting Constants From Date1 and Date2
Using DATEDIFF() function and getting the difference between two values of dates, in years.
Query
SELECT DATEDIFF(year, '2010/01/12', '2021/01/12');
Output
11
Query
Using DATEDIFF() function and getting the difference between two values of dates, in months.
SELECT DATEDIFF(month, '2010/2/12', '2021/12/12');
Output
142
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.