title: How to add date and time in Oracle
body: <p>I have the following details:</p>
  
  <p><code>date_time: 08-Dec-14 07:52:52</code> along with other fields. </p>
  
  <p>I insert using the following:</p>
  
  <pre><code>insert into employee (DATE_TIME, NAME, EMPLOYEE_ID)
   values(TO_DATE('08-Dec-14 07:52:52','DD-MON-YY HH24:MI:SS'), 'XYZ', 123);
  </code></pre>
  
  <p>When I query the database for a return of the<code>date_time</code>, I get only <strong>08-Dec-14</strong> and not the time. I have set this field as DATE. </p>
  
  <p>What changes need to be made so I can get the time as well?</p>
  
  <p>Thanks in advance. </p>