Answers for "sql query to add date column"

add colum date in sql

ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;

Posted by: Guest on March-02-2021

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

Code answers related to "sql query to add date column"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query to add date column"

Code answers related to "sql query to add date column"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query to add date column"

Code answers related to "sql query to add date column"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us