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

1 vote237 views1 answer
SQL date part only of datetime
SQL
0 vote240 views1 answer
Hibernate xml property MySQL url, username and password
SQL
1 vote224 views2 answers
Reset mysqli fetch_arra
SQL
3 votes252 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote239 views1 answer
How to reset the database value in SQL server
SQL
0 vote250 views1 answer
Alter table engine mysql
SQL
0 vote270 views1 answer
Bigrock database connection string
SQL
0 vote271 views1 answer
Sql query for login with email or username
SQL
2 votes212 views1 answer
Oracle sql drop column if exists
SQL
0 vote240 views2 answers
Get top 1 row of each group
SQL