title: Oracle — separate time and date
body: <p>I have a question with Oracle (I've installed Oracle 11g Express Edition).
  I want to insert values for 'date' and 'time', but I cannot separate them.</p>
  
  <pre><code>create table Match 
  (
      numMatch number(2) constraint PKMatch primary key,
      dateM date, 
      heureM date,
      numE_Eq number(2),
      numE_Eq2 number(2),
      nomTerrain varchar2(30)
  );
  </code></pre>
  
  <p>--"tools"=>"preferences"=>"format de date:DD/MM/YYYY  HH24:MI:SS"</p>
  
  <pre><code>insert into Match values (1,to_date
  ('10/12/2010','DD/MM/YYYY'),to_date('15:00:00','HH24:MI:SS'),1,3,'Stade Argentina'
  );
  </code></pre>
  
  <p><strong><em>result:</em></strong></p>
  
  <pre><code>dateM: 10/12/2010 00:00:00
  
  heureM: 01/11/2012 15:00:00
  </code></pre>
  
  <p>PS: I've tried to_char instead of to_date, but it didn't work at all.</p>
  
  <hr>
  
  <p>Yes, I'm aware of that 'DATE datatype contains both date and time', but it's the prof who insists showing date and time separately in the table,
  and I've seen your solutions before, but for me, it's a query, not to 'insert values' in the table.</p>
  
  <p>So I'd like to know how I can have a table directly presenting date and time.</p>