select DATEDIFF(quarter, '2001-12-01', '2002-09-30') : DATEDIFF « Date Timezone « SQL Server / T-SQL





select DATEDIFF(quarter, '2001-12-01', '2002-09-30')

 

2>
3> select DATEDIFF(quarter, '2001-12-01', '2002-09-30')
4> GO

-----------
          3

(1 rows affected)

 










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.Find the number of days between 24th March 2001 and 24th March 1964
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