数据库查询时间操作

 Oracle根据时间过滤

select * from bzcarticle where content like '%小%' and addtime<to_date('2018-07-20', 'YYYY-MM-DD');

addtime是表里的字段，字段类型是date，要查询在2018年7月20号之前的数据。这条语句是根据内容和时间两个条件过滤

---

 

Mysql根据时间过滤。basic_datetime字段类型是datetime

SELECT    count(1)  FROM  article 
LEFT JOIN basic on article.article_basicid=basic.basic_id
where   basic.basic_datetime BETWEEN  STR_TO_DATE('2019-01-01', '%Y-%m-%d') AND STR_TO_DATE('2019-06-31', '%Y-%m-%d')
ORDER BY basic_datetime DESC

 MySql时更新间

UPDATE basic SET basic_datetime='2019-08-28' WHERE basic_id BETWEEN 10519 AND 10647