/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 votes274 views2 answers
How to delete row in sql
SQL
1 vote298 views1 answer
Psql autocomplete for mac brew install
SQL
4 votes302 views1 answer
Mysql copy table with new name
SQL
0 vote306 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote295 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
2 votes320 views2 answers
Create empty table from existing table
SQL
0 vote264 views1 answer
Como leer datos de mysql esp32
SQL
0 vote303 views1 answer
Sql ignore
SQL
0 vote302 views1 answer
Oracle dynamic select into
SQL
0 vote339 views1 answer
How to use sqlcommand
SQL

Share