/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

3 votes159 views2 answers
Check data in table mysql
SQL
2 votes208 views1 answer
Merge two columns in sql oracle
SQL
0 vote207 views1 answer
Generate random & unique mysql string
SQL
5 votes159 views3 answers
Truncate function in sql oracle
SQL
0 vote157 views1 answer
Search column name sql
SQL
1 vote234 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote192 views1 answer
Convert multiple columns to ROws in sql server
SQL
12 votes169 views1 answer
Env var for setting password for root user mysql docker hub
SQL
2 votes141 views1 answer
Wait delay in sql server
SQL
2 votes151 views1 answer
Plsql block
SQL

Share