Anonymous user
Last Friday of each month: Difference between revisions
→{{header|SQL}}
Line 2,156:
connect by level < trunc( to_date ( :yr + 1 , 'yyyy' ), 'yyyy')
- trunc( to_date ( :yr, 'yyyy' ) ,'yyyy' ) + 1
group by
order by 1
</lang>
| |||
Line 2,156:
connect by level < trunc( to_date ( :yr + 1 , 'yyyy' ), 'yyyy')
- trunc( to_date ( :yr, 'yyyy' ) ,'yyyy' ) + 1
group by
order by 1
</lang>
| |||