Mysql one week ago

Mysql 1 day ago

select * 
from orders 
where order_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);

Mysql one week ago

SELECT sysdate() - 7; 				-- 1 week ago   12/01/2021 14:27:27
SELECT date(sysdate() - 7); 		-- 1 week ago   12/01/2021 00:00:00

SELECT * FROM my_table WHERE my_datecol > date(sysdate() - 7);

Mysql one week ago

select id from tbname

where date between date_sub(now(),INTERVAL 1 WEEK) and now();

Mysql get day of week

DAYOFWEEK();//(1 for Sunday,2 for Monday â€¦â€¦ 7 for Saturday )

Similar codes

1 vote173 views1 answer
Oracle undo usage per session
SQL
0 vote197 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote167 views1 answer
MySql count occurences more than"
SQL
1 vote165 views1 answer
Temp table vs variable table in sql server
SQL
1 vote195 views1 answer
Trim leading zeros in sql
SQL
0 vote185 views1 answer
Sql server rtrim everything after character
SQL
0 vote172 views1 answer
Show database not empty tables postgres
SQL
0 vote176 views1 answer
Error code 1241 mysql
SQL
0 vote165 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote175 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL