Home Forums SQL Server 2012 SQL Server 2012 - T-SQL DATEADD RE: DATEADD
Phil Parkin
SSC Guru
Points: 247210
More actions
May 28, 2014 at 4:55 am
#1716960
Ryan Keast (5/28/2014)Legend. Thanks Phil
Ryan Keast (5/28/2014)
No problem. And if you want to ignore the time component, you might like to use
dateadd(d,-7,cast(getdate() as date))
instead.