/SQL/Mysql interval 1 day

Mysql interval 1 day

Mysql 1 day ago

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

5

Mysql interval 1 day

SELECT * FROM FOO
WHERE MY_DATE_FIELD >= NOW() - INTERVAL 1 DAY

1

Source: stackoverflow.com

Similar codes

4 votes233 views4 answers
What is primary key
SQL
0 vote238 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote251 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote232 views1 answer
Drop all tables db2
SQL
0 vote235 views1 answer
Tsql generate rows
SQL
-2 votes234 views1 answer
Use of where in left join in mysql
SQL
0 vote224 views1 answer
Sqlserver now
SQL
0 vote299 views1 answer
Sqlite display headers on columns
SQL
0 vote254 views1 answer
How to run mysql in git bash
SQL
0 vote241 views1 answer
Zerar auto increment mysql
SQL

Share