title: Inserting TIME into table SQL
body: <p>I'm trying to insert a TIME value in a table in <code>SQL Developer</code>, but I get the current month returned. I am using Date as the constraint when creating the table. Sorry for the poorly written code, I'm not familiar with SQL.</p>
  
  <pre><code>INSERT INTO DELIVERY(ORDER_ID, DELIVERY_ID, DELIVERY_DATE, DELIVERY_TIME)
  VALUES(1, 1565412,('06/Sep/12'),(TO_DATE('16:18:14', 'hh24:mi:ss')));
  </code></pre>
  
  <p><strong>Output:</strong></p>
  
  <p><code>ORDER_ID DELIVERY_ID DELIVERY_DATE DELIVERY_TIME
  </code></p>
  
  <pre><code>     1     1565412 06-SEP-12     01-FEB-15     
       2     8456233 24-MAR-12     01-FEB-15     
       3     8412654 21-JUN-12     01-FEB-15     
       4     1124335 03-JUN-11     01-FEB-15     
       5     7218854 30-AUG-11     01-FEB-15 `
  </code></pre>
  
  <p>Here is the table:</p>
  
  <pre><code>CREATE TABLE DELIVERY (
  ORDER_ID      NUMBER(7),
  DELIVERY_ID   NUMBER(7) CONSTRAINT DELIVERY_ID_NN   NOT NULL,
  DELIVERY_DATE DATE      CONSTRAINT DELIVERY_DATE_NN NOT NULL, 
  DELIVERY_TIME DATE      CONSTRAINT DELIVERY_TIME_NN NOT NULL,
  PRIMARY KEY(DELIVERY_ID),
  FOREIGN KEY (ORDER_ID)  REFERENCES ORDERS(ORDER_ID)
  );
  </code></pre>
  
  <p>When I 'SELECT delivery_time FROM DELIVERY` I want to be shown the time I have inserted into the table, not the date. I don't understand why it shows me 01-FEB-15</p>