TIMESTAMP IN ORACLE ------------------------------- CREATE TABLE DEMO ( ID NUMBER PRIMARY KEY, TD_I TIMESTAMP, TD_II INTERVAL YEAR TO MONTH, /*Indicates an Interval of Year to Month : eg. Interval of 2 Years, 3 Months.*/ TD_III INTERVAL DAY TO SECOND, /*Indicates an Interval of Day to Second : eg. Interval of 2 Days,5 Hours, 5 Min and 5 Seconds.*/ TD_IV TIMESTAMP WITH LOCAL TIME ZONE, TD_V TIMESTAMP WITH TIME ZONE ); INSERT INTO DEMO(ID,TD_I,TD_II,TD_III,TD_IV,TD_V) VALUES(1,'01-JAN-2010 12:25 PM','2-3','3 10:10:10','01-AUG-2005 8:00:00 AM','01-AUG-2005 8:00:00 AM +5:30'); select * from demo; SELECT sysdate,sysdate+TD_II "Future Date",(sysdate+TD_II)-sysdate "Days Difference" FROM DEMO;