Anonymous user
Last Friday of each month: Difference between revisions
no edit summary
No edit summary |
|||
Line 2,144:
2012-11-30
2012-12-28
</pre>
=={{header|SQL}}==
<lang SQL>
select to_char( max( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1 ), 'yyyy-mm-dd Dy' )
from dual
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>
<pre>
TO_CHAR(MAX(TRUNC(TO_DA
-----------------------
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
</pre>
| |||