Search
 
SCRIPT & CODE EXAMPLE
 

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'
Comment

PREVIOUS NEXT
Code Example
Sql :: safe mysql 
Sql :: sql like query 
Sql :: mysql select column where has non int values 
Sql :: tsql random number 
Sql :: oracle index partition 
Sql :: sql select data from last week 
Sql :: check postgresql port windows 
Sql :: docker mysql random root password 
Sql :: ajouter une clé etrangere mysql 
Sql :: t-sql get duplicate rows 
Sql :: sql drop database if exists 
Sql :: Select last row from SQL Table 
Sql :: delete all content in table mysql 
Sql :: postgresql get last 10 records 
Sql :: ubuntu mysql cannot connect to database server remote 
Sql :: oracle pl sql source 
Sql :: get top 10 records in oracle 
Sql :: sql server pagination limit 
Sql :: mysql update row 
Sql :: install beautifulsoup from terminal 
Sql :: how to see the query of a view in mysql 
Sql :: sql show all users 
Sql :: sql substring before last occurrence of character 
Sql :: import large .sql files into lampp 
Sql :: mysql select tables with name like 
Sql :: identify number of rows in sql 
Sql :: how to find database collation in postgres 
Sql :: apex set debug level 
Sql :: begin transaction sql 
Sql :: mysql replace string in table 
ADD CONTENT
Topic
Content
Source link
Name
4+6 =