Last Friday of each month: Difference between revisions
Content added Content deleted
No edit summary |
(simplified) |
||
Line 2,406: | Line 2,406: | ||
=={{header|SQL}}== |
=={{header|SQL}}== |
||
<lang SQL> |
<lang SQL> |
||
select to_char( next_day( last_day( add_months( to_date( |
|||
select |
|||
:yr||'01','yyyymm' ),level-1))-7,'Fri') ,'yyyy-mm-dd Dy') lastfriday |
|||
to_char( max( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1 ), |
|||
'yyyy-mm-dd Dy' ) lastfriday |
|||
from dual |
from dual |
||
connect by level <= 12; |
|||
where |
|||
to_char ( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1, 'Dy' ) = 'Fri' |
|||
connect by level < trunc( to_date ( :yr + 1 , 'yyyy' ), 'yyyy') |
|||
- trunc( to_date ( :yr, 'yyyy' ) ,'yyyy' ) + 1 |
|||
group by |
|||
to_char( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1, 'yyyymm' ) |
|||
order by 1 |
|||
</lang> |
</lang> |
||
<pre> |
<pre> |