/SQL/Mysql 1 day ago

Mysql 1 day ago

Mysql 1 day ago

select * 
from orders 
where order_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);

5

Mysql 1 day ago

SELECT * FROM FOO
WHERE MY_DATE_FIELD >= NOW() - INTERVAL 1 DAY

1

Source: stackoverflow.com

Similar codes

9 votes103 views2 answers
Nosql databases
SQL
0 vote98 views2 answers
Nosqlbooster query other collection
SQL
0 vote114 views1 answer
Postgresql create query
SQL
2 votes103 views2 answers
Install sqlalchemy
SQL
0 vote103 views1 answer
How to drop columns with constraint from a table in sql script
SQL
2 votes112 views1 answer
Guid to string sql
SQL
0 vote121 views1 answer
How to insert same table data using mysql query
SQL
0 vote104 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote106 views1 answer
Fast sql column count
SQL
0 vote111 views1 answer
Sql #region
SQL

Share