Anonymous user
Last Friday of each month: Difference between revisions
→{{header|SQL}}
No edit summary |
|||
Line 2,148:
=={{header|SQL}}==
<lang SQL>
select
'yyyy-mm-dd Dy' ) lastfriday
from dual
where
where to_char ( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1, 'Dy' ) = 'Fri'▼
connect by level < trunc( to_date ( :yr + 1 , 'yyyy' ), 'yyyy')
group by to_char( trunc( to_date ( :yr, 'yyyy' ), 'yyyy' ) + level - 1, 'yyyymm' )
order by 1
</lang>
<pre>
LASTFRIDAY
-----------------------
2012-01-27 Fri
Line 2,170 ⟶ 2,174:
2012-11-30 Fri
2012-12-28 Fri
12 rows selected.
</pre>
| |||