1.

How To Subtract The Years, Months And Days Separately From Date

Answer»

SELECT DATE ('2003-10-13') - DEC ('03') YEARS - DEC ('07') MONTHS - DEC ('13') DAYS FROM SYSIBM.SYSDUMMY1;

SELECT DATE ('2003-10-13') - DEC ('2000') YEARS –
DEC ('27') MONTHS - DEC ('45') DAY
FROM SYSIBM.SYSDUMMY1;

SELECT DATE ('2003-10-13') - DEC ('03') YEARS - DEC ('07') MONTHS - DEC ('13') DAYS FROM SYSIBM.SYSDUMMY1;

SELECT DATE ('2003-10-13') - DEC ('2000') YEARS –
DEC ('27') MONTHS - DEC ('45') DAY
FROM SYSIBM.SYSDUMMY1;


Discussion

No Comment Found

Related InterviewSolutions