to_char(sysdate, 'yyyymmdd')
between to_char(t.f_starttime, 'yyyymmdd') and to_char(t.f_endtime, 'yyyymmdd')
把时间类型,通过to_char函授转换为字符类型,
例:
select t.f_url
from t_Cas_Role t, t_sys_user f, t_cas_user g
where 1 = 1
and t.f_cas_id = g.f_cas_id
and f.f_user_id = g.f_user_id
and t.f_url is not null
and f.f_login_name = 'admin'
and to_char(sysdate, 'yyyymmdd') between
to_char(t.f_starttime, 'yyyymmdd') and
to_char(t.f_endtime, 'yyyymmdd')