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
'DB > Oracle' 카테고리의 다른 글
| [Oracle] Interval (0) | 2016.07.22 |
|---|---|
| [Oracle] To get day of week (0) | 2016.07.01 |
| [Oracle] START WITH, CONNTECT BY (0) | 2016.04.15 |
| [Oracle] ORA-01427 (0) | 2016.04.05 |
| [Oracle] - LAST_DAY() (0) | 2016.04.05 |
리딩리드