查询某个时间字段
select * from T0010 t where t.d0130 = to_date('2012-8-23 9:45:36','YYYY-MM-DD HH24:MI:SS')
like查询
select * from T0010 t where t.d0130 like to_date('2012-8-23','YYYY-MM-DD')查询某个时间字段
select * from T0010 t where t.d0130 = to_date('2012-8-23 9:45:36','YYYY-MM-DD HH24:MI:SS')
like查询
select * from T0010 t where t.d0130 like to_date('2012-8-23','YYYY-MM-DD')