title: Incorrect date format while exporting to csv
body: <p>I am newbie to c# and I am trying to export table data from sqlite 3 database to csv but datetime format has changed in csv the format in sqlite 3 is:</p>
  
  <pre><code>2013-04-16 21:33:42.000
  </code></pre>
  
  <p>while datetime in csv is showing up like:</p>
  
  <pre><code>16/04/2013 21:33:42,
  </code></pre>
  
  <p>This is my code:</p>
  
  <pre><code>SQLiteConnection m_dbConnection;
  //m_dbConnection = new SQLiteConnection("Data Source= C:/Users/IT-Administrator/Desktop/WebMobility.db; Version=3;");
  
  m_dbConnection = new SQLiteConnection("Data source = F:/Explor/final test/WebMobility.db; Version=3;");
  m_dbConnection.Open();
  
  SQLiteCommand myCommand = new SQLiteCommand();
  myCommand.Connection = m_dbConnection;
  
  
  myCommand.CommandText = "select CompanyId,`DateTime`,Serial,ShortDeviceId,MatricolaA,Upper(Targa),CommonRoadDescription,RoadCivicNumber,GpsAddress,VerbaliVehicleTypeDescription,VehicleBrandDescription,VehicleModelDescription,CommonColorVehicleDescription,VerbaliRuleOneCode,VerbaliRuleOneDescription,VerbaliClosedNoteDescription,VerbaliRuleOnePoints,VerbaliMissedNotificationDescription  from  VerbaliData";
  //myCommand.Connection = myConn;
  DataTable data = new DataTable();
  SQLiteDataAdapter myAdapter = new SQLiteDataAdapter(myCommand);
  //myAdapter.SelectCommand = myCommand;
  myAdapter.Fill(data);
  dataGridView1.DataSource = data;
  this.dataGridView1.Refresh();
  if (dataGridView1.RowCount &gt; 0)
  {
      string value = "";
      DataGridViewRow dr = new DataGridViewRow();
      StreamWriter swOut = new StreamWriter("F:/Explor/final test/finaltest12.csv");
  
      //write header rows to csv
      for (int i = 0; i &lt;= dataGridView1.Columns.Count - 1; i++)
      {
          if (i &gt; 0)
          {
              swOut.Write(",");
          }
          swOut.Write(dataGridView1.Columns[i].HeaderText);
      }
  
      swOut.WriteLine();
  
      //write DataGridView rows to csv
      for (int j = 0; j &lt;= dataGridView1.Rows.Count - 1; j++)
      {
          if (j &gt; 0)
          {
              swOut.WriteLine();
          }
  
          dr = dataGridView1.Rows[j];
  
          for (int i = 0; i &lt;= dataGridView1.Columns.Count - 1; i++)
          {
              if (i &gt; 0)
              {
                  swOut.Write(",");
              }
  
              value = dr.Cells[i].Value.ToString();
              //replace comma's with spaces
              value = value.Replace(',', ' ');
              //replace embedded newlines with spaces
              value = value.Replace(Environment.NewLine, " ");
  
              swOut.Write(value);
          }
      }
      swOut.Close();
  }
  
  m_dbConnection.Close();
  </code></pre>