oracle如何模糊查询指定月份的数据,日期列为varchar2()类型日期数据2015-05-04

select a.whir$t3079_owner ,a.whir$t3079_date ,a.whir$t3079_org ,a.whir$t3079_f4063 ,a.whir$t3079_f4065 ,a.whir$t3079_f5358,a.whir$t3079_f4060 from
whir$t3079 a where a.whir$t3079_owner=13904404 and a.whir$t3079_workstatus=100 and a.whir$t3079_date

a.whir$t3079_date=?参数怎么写

select * from 表名 where to_char(日期列名,'yyyymm')='201505';

select to_date('2013-04-18 14:07:48','yyyy-mm-dd hh24:mi:ss') from dual;

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息