using DAYS from DB2

|

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
prev | 1 | 2 | 3 | 4 | 5 | next