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

0 vote263 views1 answer
Sql server python connection
SQL
1 vote208 views1 answer
Clear screen command in psql
SQL
1 vote203 views1 answer
Sql run multiple updates in one query
SQL
0 vote236 views1 answer
Insert output identity
SQL
5 votes208 views1 answer
Oracle get nls settings
SQL
2 votes206 views2 answers
Mysql bidirectional composite primary key
SQL
18 votes189 views3 answers
Mysql query add column with default string value
SQL
0 vote302 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote193 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote168 views1 answer
Convert money to varchar sql server
SQL