select * from rms_stat_info_value_month where tjfxlx='资源数量' and to_date(tjtime,'yyyy/MM/dd')>to_date('2010-01-01','yyyy/MM/dd') and to_date(tjtime,'yyyy/MM/dd')<to_date('2010-12-01','yyyy/MM/dd') 是不是哪里写错了?忙活了很久了!
select * from rms_stat_info_value_month where tjfxlx='资源数量' and to_date(tjtime,'yyyy/MM/dd')>to_date('2010-01-01','yyyy/MM/dd') and to_date(tjtime,'yyyy/MM/dd')<to_date('2010-12-01','yyyy/MM/dd')-- 要不就把所有的 "/"字符换成"-",反之亦可!
select * from rms_stat_info_value_month where tjfxlx='资源数量' and (to_date(tjtime,'yyyy-MM-dd')>to_date('2010-01-01','yyyy-MM-dd') and to_date(tjtime,'yyyy-MM-dd')<to_date('2010-12-01','yyyy-MM-dd'))
select *
from rms_stat_info_value_month
where tjfxlx='资源数量'
and (to_date(tjtime,'yyyy-MM-dd')>to_date('2010-01-01','yyyy-MM-dd')
and to_date(tjtime,'yyyy-MM-dd')<to_date('2010-12-01','yyyy-MM-dd'))