Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Declare @StartDate Date = DateAdd(dd, -1, GetDate())
- Where SomeDATE = @StartDate
- Where SomeDATE = '2018-02-21'
- Declare @StartDate Date = DateAdd(dd, -2, GetDate())
- Declare @EndDate Date = GetDate()
- Where (SomeDATE > @StartDate And SomeDATE < @EndDate)
- Where SomeDATE = DateAdd(dd, -1, GetDate())
- Where SomeDATE = Cast(DATEADD(dd, -1, GetDate()) As Date)
Add Comment
Please, Sign In to add comment