Time Stamp value not inserting in oracle

I have following table in Oracle:

DESC TIME_PERIOD
Name       Null     Type         
---------- -------- ------------ 
TIME_ID    NOT NULL NUMBER(2)    
START_TIME NOT NULL TIMESTAMP(6) 
END_TIME   NOT NULL TIMESTAMP(6) 

I am inserting values, but values are not inserted. I am using the following query.

INSERT INTO TIME_PERIOD (START_TIME,END_TIME)
   VALUES (1, TO_DSINTERVAL('0 23:59:59'), TO_DSINTERVAL('0 23:59:59'));

How can I insert value in Oracle?


Source: oracle

Leave a Reply