/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 votes337 views1 answer
To date oracle with time
SQL
0 vote347 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote343 views1 answer
Postgres declare variable
SQL
0 vote364 views1 answer
Group by two columns postgres
SQL
5 votes361 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote340 views1 answer
Add plugins to mysql workbench
SQL
0 vote352 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote380 views1 answer
How to use db.execute
SQL
0 vote352 views1 answer
Mysql bind-address default value
SQL
5 votes382 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL

Share