title: Implicit conversion of date field in a pl/sql trigger?
body: <p>I need to develop a trigger in PL/SQL (Oracle) <code>before INSERT</code>.</p>
  
  <p>In this table there is a column (<code>cdat</code>) of type DATE.</p>
  
  <p>Let's say i do <code>INSERT INTO myTbl (123,'12/05/2011');</code></p>
  
  <p>In my trigger the <code>:NEW.CDAT</code> is converted in the final date system or it's still a varchar?</p>
  
  <p>Do I need to do a <code>TO_DATE(:NEW.CDAT)</code> to get the date value?</p>