Answers for "not add date in sql"

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

sql server today minus n

SELECT GETDATE() - 1

Posted by: Guest on April-08-2020

Code answers related to "not add date in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "not add date in sql"

Code answers related to "not add date in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "not add date in sql"

Code answers related to "not add date in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us