Select * from a where date between to_date(‘2018-1-1’, ‘yyyy-mm-dd’) and to_date(‘2018-8-1’,‘yyyy-mm-dd’)
查询结果
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/789dd897a1a55639210730d383e240a5.png)
1)select * from tableName t where start_times > to_date(‘2015/6/26 10:00:00’,‘yyyy/mm/dd hh24:mi:ss’);
2)select * from tableName t where start_times < to_date(‘2015/6/26 10:00:00’,‘yyyy/mm/dd hh24:mi:ss’);