Selecting User-Defined Variables From Date1 and Date2
Using DATEDIFF() function and getting the difference between the two values of dates using variables which includes time as well, in second.
Example
DECLARE @date1 VARCHAR(50);
DECLARE @date2 VARCHAR(50);
SET @date1 = '2019/2/1 09:55:44';
SET @date2 = '2020/12/12 07:45:22';
SELECT DATEDIFF(second, @Start_date, @End_date);
Output
58744178
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.