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 vote152 views1 answer
Mysql exception output
SQL
6 votes235 views3 answers
Psql show columns of table
SQL
0 vote140 views2 answers
Sql drop view if exists
SQL
6 votes159 views2 answers
Mysql timestamp to date
SQL
0 vote193 views1 answer
Radius search with point data in mysql
SQL
0 vote143 views1 answer
Google sheets filter rows above current cell
SQL
0 vote166 views1 answer
Sql tablo sp
SQL
5 votes145 views3 answers
Mysql remove unique constraint
SQL
3 votes132 views1 answer
Postgresql if null then 0
SQL
4 votes138 views1 answer
Restart for pg_hba.conf file
SQL