Select last 30 days sql

Sql last 7 days

 SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on
 FROM News 
 WHERE CreatedDate >= DATEADD(day,-7, GETDATE())

Source: stackoverflow.com

Select last 30 days sql

--EXAMPLE -30 days
select o_orderkey, o_orderstatus, o_orderdate, o_totalprice from orders where o_orderdate >= current_date -30

Similar codes

11 votes548 views4 answers
Reset identity column values in sql server
SQL
17 votes164 views2 answers
Mysql date to string
SQL
2 votes223 views3 answers
Mysql unix timestamp to date
SQL
0 vote169 views1 answer
Db format in quotation
SQL
0 vote163 views1 answer
No suitable driver found for sqlite
SQL
4 votes172 views3 answers
Rename table column postgresql
SQL
50 votes183 views4 answers
Sql alter type of column
SQL
6 votes211 views3 answers
Rename column ORACLE
SQL
0 vote182 views1 answer
How to run mysql on terminal mac
SQL
1 vote181 views1 answer
Ora-01109 database not open in oracle 19c
SQL