Anonymous user
Last Friday of each month: Difference between revisions
Undo revision 231020 by Vince refiti (talk)
No edit summary |
(Undo revision 231020 by Vince refiti (talk)) |
||
Line 2,831:
</pre>
=={{header|
<lang
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>
LASTFRIDAY
-----------------------
2012-01-27 Fri
2012-02-24 Fri
2012-03-30 Fri
2012-04-27 Fri
2012-05-25 Fri
2012-06-29 Fri
2012-07-27 Fri
2012-08-31 Fri
2012-09-28 Fri
2012-10-26 Fri
2012-11-30 Fri
2012-12-28 Fri
12 rows selected.
</pre>
|