title: datetime argument data type varchar is invalid for argument 3 of convert function
body: <p>I am trying to populate a table in my database with the following:</p>
  
  <pre><code>INSERT INTO student 
  VALUES (102, 'Mr.', 'Fred', 'Crocitto', '101-09 120th St.', '11419', '718-555-5555', 
          'Albert Hildegard Co.', '22-JAN-03', 'BROSENZWEIG',
          CONVERT(DATETIME, '19-JAN-2007 00:00: 00','DD-MON-YYYY HH24:MI:SS'),
          'BROSENZW', CONVERT(DATETIME, '22-JAN-2007 00:00:00', 'DD-MON-YYYY HH24:MI:SS'));  
  </code></pre>
  
  <p>When I execute it, I get this error message: </p>
  
  <blockquote>
    <p>Msg 8116, Level 16, State 1, Line 2<br>
    Argument data type varchar is invalid for argument 3 of convert function</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>