title: creating table in Oracle with Date
body: <p>I want to create a table in Oracle 10g and I want to specify the date format for my date column. If I use the below syntax:</p>
  
  <pre><code>create table datetest(
  ........
  startdate date);
  </code></pre>
  
  <p>Then the date column will accept the date format <code>DD-MON-YY</code> which I dont want.</p>
  
  <p>I want the syntax for my date column to be <code>MM-DD-YYYY</code></p>
  
  <p>Please let me know how to proceed with this.</p>
  
  <p>Regards,</p>