hi all,
i am using db10g.
i have to add numeric field (year) to the date column
something like if i have date like 03-mar-2000 means i have to add 2 year to the existing year the result should be something like
03-mar-2002
i tried like below
SELECT EMP_DOJ
FROM EMPLOYEE_MASTER
WHERE EMP_CODE = '0016108'
EMP_DOJ
---------
01-MAR-00
SELECT EMP_DOJ + 2
FROM EMPLOYEE_MASTER
WHERE EMP_CODE = '001610'
EMP_DOJ+2
---------
03-MAR-00
in the result set only date is getting added but i want to add year.
How can i add year. any format is required?
Thanks..