/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

5 votes259 views1 answer
AND OR NOT operators sql
SQL
38 votes332 views6 answers
Ubuntu install mysql client
SQL
16 votes238 views3 answers
Order by sql query
SQL
0 vote233 views1 answer
Metada in sql
SQL
0 vote208 views2 answers
How to combine two sql queries in one result
SQL
49 votes290 views6 answers
Alter table add column
SQL
0 vote287 views1 answer
Mysql get first 2 characters of string
SQL
1 vote273 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
11 votes259 views5 answers
How to install sqlite3 python
SQL
1 vote258 views1 answer
Flask sqlalchemy filter multiple conditions
SQL

Share