title: Inserting system date in oracle
body: <p>How to insert system date in dd/mm/yyyy to table using oracle 10g?</p>
  
  <p>While using the following query, it inserts system date as 03/04/0013. I need 03/04/2013. Can you help me to solve this problem?</p>
  
  <pre><code>insert into GtTable 
  values('111','Name',300,'Tour',to_date('02/04/2012','DD/MM/YYYY'),to_date(sysdate,'DD/MM/YYYY'));
  </code></pre>
  
  <p>But when inserting '02/04/2012' directly, it accepts as same as '02/04/2012'.</p>