求一段連續日期,但排除六日 自已標記一下,方便以後查尋 无 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 rown
求一段連續日期,但排除六日
自已標記一下,方便以後查尋
1 2 3 4 5 | 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
|
Copy after login