Answers for "dateadd in sql server"

sql server current date minus 5 years

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'

Posted by: Guest on May-28-2020

3 days back in sql server

DATEADD(DAY, -3, GETDATE())

Posted by: Guest on November-30-2020

Code answers related to "dateadd in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "dateadd in sql server"

Code answers related to "dateadd in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "dateadd in sql server"

Code answers related to "dateadd in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us