DATEDIFF(d, @thisdate, @nextmonth) 'Days between' : DATEDIFF « Date Timezone « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Date Timezone
3. DATEDIFF

DATEDIFF(d, @thisdate, @nextmonth) 'Days between'

3> DECLARE @thisdate datetime, @nextmonth datetime
4>
5> SET @thisdate = GETDATE()
6> SET @nextmonth = DATEADD(m, 1, GETDATE())
7>
8> SELECT CONVERT(varchar, @thisdate, 101) 'Today',
9>     CONVERT(varchar, @nextmonth, 101) 'One month from today',
10>     DATEDIFF(d, @thisdate, @nextmonth) 'Days between'
11> GO
Today                          One month from today           Days between
------------------------------ ------------------------------ ------------
10/12/2006                     11/12/2006                               31

(1 rows affected)
1>
           
       

Related examples in the same category