Home/ Questions/How to get current date minus 5 years in sqlserver?
In Process
Jules Benoist
  • 28
Asked: 2022-05-21T19:02:08+00:00 In:

How to get current date minus 5 years in sqlserver?

  • 28

. Advertisement .

..3..

. Advertisement .

..4..

How can I get current date minus 5 years in sqlserver? I will be thankful for your solutions.

♦ Suggestions of ITtutoria Team
This method is used to find when a particular date occurred 5 years ago. To execute the get current date minus 5 years in sqlserver query, use the following syntax:
SELECT getdate() – INTERVAL -5 YEAR

Share

1 Answer

  1. I hope my tip may help you

    SELECT GETDATE() 'Today', 
           DATEADD(day,-2,GETDATE()) 'Today - 2 Days'
SELECT GETDATE() 'Today', 
           DATEADD(dd,-2,GETDATE()) 'Today - 2 Days'
SELECT GETDATE() 'Today', 
           DATEADD(d,-2,GETDATE()) 'Today - 2 Days'
​
    • 17

Leave an answer

You must login to add an answer.

Need An Account,