title: How to read from mysql datetime field
body: <p>I'm trying to read from mysql field with datetime type and I was trying everything and always it's return field name only.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>using (MySqlConnection connection = new MySqlConnection(ConnectionString))
  {
      connection.Open();
  
      string query = @"SELECT `sID`, 'sDate', `sGameLogin`, `dGameAmount`, 
                      'sPayMethod' FROM `XeronRequests` WHERE `iStatus` = 0";
  
      MySqlCommand cmd = new MySqlCommand(query, connection);
      cmd.CommandType = CommandType.Text;
  
      using (MySqlDataReader dataReader = cmd.ExecuteReader())
      {                    
          while (dataReader.Read())
          {
              list.Add(new PaymentInfoText(dataReader["sID"] + "", 
                       dataReader["sDate"] + "", 
                       dataReader["sGameLogin"] + "", 
                       dataReader["dGameAmount"] + "", 
                       dataReader["sPayMethod"] + ""));
          }
      }
  
      e.Result = list;
  }
  </code></pre>