从DB中获取日期并将其格式化为C#

using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "server=localhost;database=mydatabase;uid=username;password=password";
        string query = "SELECT dateColumn FROM myTable";

        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            MySqlCommand command = new MySqlCommand(query, connection);
            MySqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                DateTime date = reader.GetDateTime("dateColumn");
                string formattedDate = date.ToString("yyyy-MM-dd");
                Console.WriteLine(formattedDate);
            }

            reader.Close();
        }
    }
}