SELECT
DAY('2013-03-03') - DAYS(TO_CHAR(TO_DATE(CHAR(HEX(CURRENT DATE)), 'YYYY-MM-DD'), 'YYYY-MM-DD'))
from sysibm.sysdummy1
---------------------------------------------------------------------------------------------------------
'DB' 카테고리의 다른 글
| SEQUENCE (0) | 2013.12.12 |
|---|---|
| using DAYS from DB2 (0) | 2013.10.20 |
Trackback 0 And
Comment 0
