Thursday, November 25, 2010

Adding Time Units to SYSDATE

SELECT SYSDATE + INTERVAL '30' MINUTE
FROM SYS.DUAL


simply nice ^^ <3

l_performance_rating_year1 VARCHAR2(10) := TO_CHAR(SYSDATE - INTERVAL '3' YEAR, 'YYYY');
l_performance_rating_year2 VARCHAR2(10) := TO_CHAR(SYSDATE - INTERVAL '2' YEAR, 'YYYY');
l_performance_rating_year3 VARCHAR2(10) := TO_CHAR(SYSDATE - INTERVAL '1' YEAR, 'YYYY');

No comments:

Post a Comment