Last Friday of each month: Difference between revisions
Content added Content deleted
| Line 2,156: | Line 2,156: | ||
connect by level < trunc( to_date ( :yr + 1 , 'yyyy' ), 'yyyy') |
connect by level < trunc( to_date ( :yr + 1 , 'yyyy' ), 'yyyy') |
||
- trunc( to_date ( :yr, 'yyyy' ) ,'yyyy' ) + 1 |
- trunc( to_date ( :yr, 'yyyy' ) ,'yyyy' ) + 1 |
||
group by |
|||
to_char( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1, 'yyyymm' ) |
|||
order by 1 |
order by 1 |
||
</lang> |
</lang> |
||