title: Oracle Partition Interval by day - wrong high value?
body: <p>I created a table with the following partition interval:</p>
  
  <pre><code>create table 
  pos_data_two ( 
      start_date        TIMESTAMP,
      store_id          NUMBER,
      inventory_id      NUMBER(6),
      qty_sold          NUMBER(3)
   ) 
   PARTITION BY RANGE (start_date) 
   INTERVAL(NUMTODSINTERVAL (1, 'DAY')) 
   (  
    PARTITION pos_data_p2 VALUES LESS THAN (TO_DATE('30.10.2013', 'DD.MM.YYYY'))
   ); 
  </code></pre>
  
  <p>When I insert a a row with the timestamp value</p>
  
  <pre><code>'31.10.2013 00:00:00'
  </code></pre>
  
  <p>The high value of the new created partition is:</p>
  
  <pre><code>TIMESTAMP' 2013-11-01 00:00:00'
  </code></pre>
  
  <p>Is that correct? Shouldn't it be 2013-10-31 00:00:00 ??</p>