//字符串转换为时间
select t.*, t.rowid from cdpf_log t where edittime=to_date('2008-09-08 21:13:14','yyyy-mm-dd hh24:mi:ss')
//时间转换为字符串
select * from tablename a where to_char(日期字段,'yyyymm')='200312'
//字符串转换为时间
select t.*, t.rowid from cdpf_log t where edittime=to_date('2008-09-08 21:13:14','yyyy-mm-dd hh24:mi:ss')
//时间转换为字符串
select * from tablename a where to_char(日期字段,'yyyymm')='200312'