title: I have DD-MON-RR HH24.MI.SS format date to get inserted in oracle table, how can I define the DATE in CTL file?
body: <p>SQL CTL : I have DD-MON-RR HH24.MI.SS format date to get inserted in oracle table, how can I define the DATE in CTL file?</p>
  <p>Have defined date in ctl file as</p>
  <pre><code>C_DATE DATE &quot;DD-MON-YY HH24:MI:SS&quot; 
  </code></pre>
  <p>I have no error in logs, but data inserted in table is in another format. Please guide which format should I give in CTL file to get the date inserted in correct format.</p>