title: Inserting date in sql server
body: <p>When I try to execute this query </p>
  
  <pre><code>INSERT  INTO StateRegion
          ( FullName ,
            Abbreviation ,
            RegionType ,
            Admitted ,
            Capital
          )
  VALUES  ( 'Alabama' ,
            'AL' ,
            1 ,
            '1819-Dec-14' ,
            'Montgomery'
          );
  </code></pre>
  
  <p>it gives me error sql date conversion error : </p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character
    string</p>
  </blockquote>
  
  <p>Admitted is a Date type.</p>
  
  <p>The issue is I can not change this format : <code>1819-Dec-14</code>, is it possible to add convert method to the query above ?</p>
  
  <p>Table definition :</p>
  
  <pre><code>CREATE TABLE StateRegion
  (
    ID            bigint       PRIMARY KEY IDENTITY(1,1),
    FullName      varchar(50)  NOT NULL,
    Abbreviation  varchar(2)   NOT NULL,
    RegionType    smallint     NOT NULL,
    Admitted      date         NULL,
    Capital       varchar(50)  NULL
  );
  </code></pre>