这是SQL与语句:
select to_char(last_modify_time-(to_char(last_modify_time,'d')-1-1),'yyyy-MM-dd') as field ,
count(*) as total,count(decode(links,64, 1, null)) as outter
from t_file_info_222222
group by to_char(last_modify_time-(to_char(last_modify_time,'d')-1-1),'yyyy-MM-dd')
order by to_char(last_modify_time-(to_char(last_modify_time,'d')-1-1),'yyyy-MM-dd') DESC
这是执行结果
需求是:结果要以15天为间隔时间,上面的结果是7天的间隔时间,SQL语句怎么改写?急!!!