ORACLE to_date Date类型查询

Date类型字段查询时

select * fromtopenday d where d.d_date = to_date('2016-10-08','yyyy-mm-dd')