title: Date Insertion Issue in Oracle Database and Codeigniter
body: <p>I am having a problem in updating oracle db table with date column . I have tried many solutions but still not working. <strong>I can not insert the date into the database</strong> using codeigniter active record or normal query..  the column type is Timestamp. here are some solutions I have tried. could u help please.. thank you </p>
  
  <pre><code> $this-&gt;db-&gt;set('AC_START',"TO_DATE('2014-03-4 2:30','yyyy-mm-dd hh:mm')");
   $this-&gt;db-&gt;set('AC_END',"TO_DATE('2014-05-5 2:34' ,'yyyy-mm-dd hh:mm')");
   $this-&gt;db-&gt;insert('ACTIVITES');
  </code></pre>
  
  <p>here is error message that I always get </p>
  
  <p>Error Number:</p>
  
  <pre><code>INSERT INTO "LI_PPPA"."ACTIVITES" ("AC_START", "AC_END") VALUES ('TO_DATE('2014-03-4 2:30','yyyy-mm-dd hh:mm')', 'TO_DATE('2014-05-5 2:34' ,'yyyy-mm-dd hh:mm')')
  </code></pre>
  
  <p><strong>Filename:</strong>  Directory\program\system\database\DB_driver.php
  Line Number: 330</p>