Home Forums SQL Server 2008 T-SQL (SS2K8) GetDate() 5 Years ago without time formated 'YYYY-MM-DD' RE: GetDate() 5 Years ago without time formated 'YYYY-MM-DD'
Cadavre
SSC-Forever
Points: 41690
More actions
June 24, 2013 at 1:45 am
#1626674
Since we're talking about SQL Server 2008 here, any issue with using the date type?
SELECT CONVERT(DATE, DateAdd(yy, - 5, GetDate()));