Selecting Constants from Date1 and Date2 with Hours
Using DATEDIFF() function and getting the difference between the two values of dates which includes time as well, in hour.
Query
SELECT DATEDIFF(hour, '2019/2/1 09:55', '2020/12/12 07:45');
Output
16318
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.