title: Date type without time in Oracle
body: <p>In Oracle 10g I got a problem when using <code>DATE</code> type in my table. I just want my <code>DATE</code> field store only <code>DATE</code> without time automatically.</p>
  
  <p>There's so much solution, I know it like using <code>TO_CHAR</code> and <code>TO_DATE</code> or <code>TRUNC</code> but I faced that I'm using so much procedures to insert or update data and have no time to update all of them.</p>
  
  <p>How could I resolve this problem?</p>