title: sqlite throwing a "String not recognized as a valid datetime"
body: <p>I am playing around with Sqlite and keep getting an error when trying to read back some test data. For example, I created a simple db with a single table and some columns and populated it with some test data as shown below.</p>
  
  <pre><code>sqlite&gt; .schema
  CREATE TABLE "shows"(id integer primary key asc autoincrement, showName TEXT, guest TEXT, dateAired date, dateWatched date);
  
  sqlite&gt; select * from shows;
  6|test show|test guest 1|2012.05.01|2012.07.10
  7|test show|test guest 2|2012.05.02|2012.07.10
  8|test show|test guest 4|2012.05.04|2012.07.10
  </code></pre>
  
  <p>I am using the System.Data.Sqlite library available <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki" rel="noreferrer">here</a> , but it keeps giving me an error while trying to read the date column. I tried putting the dates in the dd-MM-yyyy format, but still get an error saying "String Not Recognized as a valid datetime." I have tried using DateTime.Parse or casting it to datetime or just ToString()'ing it to see what happens, but I keep getting the same error. I can read the text fields fine, but can't read the date fields. </p>
  
  <p>My C# code snipped is given below</p>
  
  <pre><code>var sqliteConn = new SQLiteConnection("Data Source=data/shows.db;Version=3;New=False;Compress=True");
  sqliteConn.Open();
  SQLiteCommand cmd = new SQLiteCommand(sqliteConn);
  cmd.CommandText = "select * from shows";
  
  SQLiteDataReader reader = cmd.ExecuteReader( );
  while (reader.Read( ))
      {
      var showName = reader["showName"];
      // This is where it keeps giving me an error.
      // I have tried various things such as DateTime.Parse
      var airedDate = DateTime.ParseExact("yyyy.MM.dd", reader["dateAired"].ToString(), new CultureInfo("en-AU"));
       }
  reader.Close( );
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>Regards,</p>