DB/Oracle
[Oracle] How to get a weekend
리딩리드
2016. 6. 7. 16:06
How to get a weekend
select t.*,rowid
from tdelyday t
where t.dely_gb = '00'
and TO_CHAR(t.yymmdd, 'D') in( '1','7')
- 1 is sunday
- 7 is saturday