title: How do I insert datetime value into a SQLite database?
body: <p>I am trying to insert a datetime value into a <a href="http://en.wikipedia.org/wiki/SQLite" rel="noreferrer">SQLite</a> database. It seems to be sucsessful but when I try to retrieve the value there is an error:</p>
  
  <blockquote>
    <p>&lt;Unable to read data></p>
  </blockquote>
  
  <p>The SQL statements are:</p>
  
  <pre><code>create table myTable (name varchar(25), myDate DATETIME)
  insert into myTable (name,mydate) Values ('fred','jan 1 2009 13:22:15')
  </code></pre>