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

7 votes251 views1 answer
Safe mode mysql
SQL
0 vote267 views2 answers
Drop tables from local table database postgres
SQL
0 vote268 views1 answer
Mysql change innodb to myisam
SQL
1 vote254 views2 answers
Login to mysql
SQL
10 votes209 views2 answers
Django mysql
SQL
0 vote285 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote255 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
2 votes273 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote286 views1 answer
Get role postgres
SQL
1 vote233 views1 answer
Foreign key constraint in ms sql
SQL