MSSQL DATE function [database query integer day or integer month]

MSSQL Date function [query integer day or integer month in database Tutorial]

Select//query for the entire month
*
From
Tb
where
DateDiff (hh, Time field, GETDATE ()) =0

Select DATEADD (Mm,2,getdate ())
Select DATEADD (Day,2,getdate ())

Query Day and Hour

DateDiff (Dd,time,getdate ())--Day
DateDiff (Hh,time,getdate ())--hour

Query the current

SELECT * from #tb where DATEADD (Mm,2,datacol) =getdate ()

Querying all the data now

Select
*
From
Tb
where
DateDiff (hh, Time field, GETDATE ()) =0--When
and DateDiff (MI, Time field, GETDATE ()) =0--seconds

Using Stored Procedures

DECLARE @num int
Set @num =2
If DateAdd (d, @num, ' 2010-01-05 1:00 ') =getdate () or DATEADD (m,2, ' 2010-01-05 1:00 ') =getdate ()
print ' is '
Else
print ' not '

Detects whether the current time is longer than the whole number of days or months