title: create table with time datatype and insertion time data in table
body: <p>I want to insert a time data in a table . So, what type of datatypes, I should use and how can I insert a time in a table? I used 'timestamp' in create table statement, but when I insert a time in table, it shows an error (error-code : ORA-01861). Please help me.  I use ORACLE 11g.</p>
  
  <p>DDL statement:</p>
  
  <pre><code> CREATE TABLE "SOM"."FLIGHTS" 
     (    "FLNO" NUMBER(3,0) NOT NULL ENABLE, 
      "FROM" VARCHAR2(20 BYTE), 
      "TO" VARCHAR2(20 BYTE), 
      "DISTANCE" NUMBER(5,3), 
      "DEPARTS" TIMESTAMP (3), 
      "ARRIVES" TIMESTAMP (3), 
      "PRICE" NUMBER(5,2), 
       CONSTRAINT "FLIGHTS_PK" PRIMARY KEY ("FLNO")   );
  </code></pre>
  
  <p>insert statement:  </p>
  
  <pre><code>insert into flights 
  values (1, 'Bbsr', 'Calcutta', 600, timestamp '05:30', timestamp '06:50', 8000);
  </code></pre>