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'
J Livingston SQL
SSC Guru
Points: 51550
More actions
June 23, 2013 at 10:58 am
#1626616
SELECT convert(varchar(10), DateAdd(yy, -5, GetDate()),120)
________________________________________________________________you can lead a user to data....but you cannot make them think and remember....every day is a school day