Last Friday of each month: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 2,144: | Line 2,144: | ||
2012-11-30 |
2012-11-30 |
||
2012-12-28 |
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> |
</pre> |
||