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