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

0 vote201 views1 answer
ORA-13717
SQL
0 vote194 views1 answer
Get who is hired in month in sql
SQL
0 vote191 views1 answer
Sql get guid
SQL
0 vote191 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
3 votes242 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote200 views1 answer
Oracle c# multiple update sql
SQL
1 vote174 views1 answer
Mysql select utc time in eastern time
SQL
1 vote202 views2 answers
How to add amount between date in sql
SQL
0 vote192 views1 answer
Select from another database
SQL
0 vote213 views2 answers
While mysql
SQL