/SQL/Select the date 30 days less that the todays date sql request

Select the date 30 days less that the todays date sql request

Select the date 30 days less that the todays date sql request

declare @thirtydaysago datetime
declare @now datetime
set @now = getdate()
set @thirtydaysago = dateadd(day,-30,@now)

select @now, @thirtydaysago

0

Source: stackoverflow.com

Similar codes

12 votes147 views4 answers
Mysql version
SQL
0 vote142 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote154 views1 answer
Create table using the clause with as
SQL
13 votes152 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote140 views1 answer
Create synonym for dblink in oracle
SQL
11 votes143 views2 answers
Oracle source code
SQL
8 votes139 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote142 views1 answer
How to install sql in anaconda
SQL
5 votes99 views1 answer
Mongodb vs
SQL
0 vote163 views1 answer
Replace \n sql
SQL

Share