title: Can't insert date into SQL table
body: <p>I've created the following table:</p>
  
  <pre><code>CREATE TABLE match(
  match_id NUMBER(4,0), 
  match_date DATE, 
  attendance NUMBER(6,0), 
  stadium_name VARCHAR2(40), 
  tournament_id NUMBER(3,0),
  CONSTRAINT match_id_pk PRIMARY KEY(match_id),
  CONSTRAINT match_stadium_name_fk FOREIGN KEY(stadium_name) 
             REFERENCES stadium(stadium_name));
  </code></pre>
  
  <p>I attempt to insert the following line:</p>
  
  <pre><code>INSERT INTO match VALUES(1001, '20130515', 90000, 'American Airlines Arena', 001);
  </code></pre>
  
  <p>Everything I've found tells me the format is YYYYMMDD.  However I keep getting ORA-01861: literal does not match format string.</p>
  
  <p>After using (<code>DESCRIBE match</code>) it says the length is only 7.  I thought it was supposed to be 10.</p>
  
  <p>Thanks in advance for any help.</p>