/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

48 votes278 views3 answers
Psql create database
SQL
0 vote126 views1 answer
Mysqli or pdo
SQL
21 votes236 views6 answers
Update sql
SQL
0 vote187 views1 answer
How to select even id in sql
SQL
0 vote176 views1 answer
How to save data in database in mysql node
SQL
0 vote202 views1 answer
Alter domain sql
SQL
2 votes230 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote163 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote193 views1 answer
How to remove quotes from a string in ssis load file
SQL
-2 votes178 views2 answers
Union vs union all in sql
SQL

Share