Find the number of days between 24th March 2001 and 24th March 1964


1> -- Find the number of days between 24th March 2001 and 24th March 1964 using
2>
3> SELECT DATEDIFF(dd, "24 March 2001","24 March 1964")
4> GO

-----------
     -13514

(1 rows affected)
1>

Related examples in the same category

1.	DATEDIFF: return the difference between two dates
2.	select DATEDIFF(second, '06:46:45', '11:35:00')
3.	select DATEDIFF(quarter, '2001-12-01', '2002-09-30')
4.	DATEDIFF(yyyy, "24 March 2001","24 March 1964")
5.	DATEDIFF(mi, "24 March 2001","24 March 1964")
6.	DATEDIFF(wk, "24 March 2001","24 March 1964")
7.	DATEDIFF(m, "24 March 2001","24 March 1964")
8.	DATEDIFF(d, @thisdate, @nextmonth) 'Days between'
9.	DATEDIFF(month, '9-8-1989', '10-17-1991')
10.	DATEDIFF(day, '9-8-1989', '10-17-1991')
11.	Difference in weeks between 7-2-1996 and 8-4-1997
12.	DATEDIFF(ss, @MyBirthDate, GETDATE())
13.	select DATEDIFF(hour, '06:46:45', '11:35:00')
14.	select DATEDIFF(minute, '06:46:45', '11:35:00')
15.	Difference between the current time and UTC
16.	DATEDIFF: date difference
17.	Combine DateADD and DateDIFF to get the last date of a month
18.	Passing a column name to the DATEDIFF() value argument

Find the number of days between 24th March 2001 and 24th March 1964 : DATEDIFF « Date Timezone « SQL Server / T-SQL

Related examples in the same category