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'

  • 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