select allday from ( select to_date('2007-02-15','yyyy-mm-dd')+rownum allday from (select to_date('2007-02-15','yyyy-mm-dd'),to_date('2007-02-28','yyyy-mm-dd') from dual) connect by rownum < to_date('2007-02-28','yyyy-mm-dd')-to_date('2007-02-15','yyyy-mm-dd') ) where to_char(allday,'D') >1 and to_char(allday,'D') <7
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....