SELECT CURRENT DATE + 30 DAYS
FROM SYSIBM.SYSDUMMY1
;
SELECT A.Q41EUYM,
LEFT(REPLACE(CHAR((CAST(LEFT('20100301',4)||'-'||SUBSTRING('20100301',5,2)||'-'||'01' AS DATE) - 3 MONTH)), '-', ''),6) AS FDT,
A.*
FROM CLVDTALB.TQ41FAA0 A
FETCH FIRST 100 ROWS ONLY
;
SELECT CAST(LEFT('2010',4)||'-'||SUBSTRING('20100201',5,2)||'-'||'01' AS DATE) - 3 MONTH FROM SYSIBM.SYSDUMMY1
;
SELECT CAST('2010-01-01' AS DATE) - 3 MONTH FROM SYSIBM.SYSDUMMY1
;
SELECT REPLACE(CHAR(DATE(CURRENT DATE)), '-', ''),/* 작업일자 */
TIME(CURRENT TIME)/* 작업시간 *///2010.08.23.->: 수정 by 최인욱
FROM SYSIBM.SYSDUMMY1
;
CASE WHEN DAYS(INSERT(INSERT(CAST('20100625' AS CHAR(8)),5,0,'-'),8,0,'-'))
- DAYS(INSERT(INSERT(R63IDT,5,0,'-'),8,0,'-')) > 365 THEN 0
ELSE IFNULL(R63SAM,0) + IFNULL(R63VAM,0) - IFNULL(R64RAM,0) END AGING
SELECT CURRENT TIMESTAMP
INTO :ldt_GetDate
FROM SYSIBM.SYSDUMMY1
USING SQLCA ;
오늘에서 지난 달을 뺀 달 수 계산하기
SELECT MONTH(CAST('2010-03-01' AS DATE)) - MONTH(CAST('2010-01-01' AS DATE))
FROM SYSIBM.SYSDUMMY1 ;
