检查给定日期是否在c#和mySql中的当前日期之前

DateTime givenDate = new DateTime(2022, 1, 1); // 假设给定日期为2022年1月1日

if (givenDate < DateTime.Now)
{
    Console.WriteLine("给定日期在当前日期之前");
}
else
{
    Console.WriteLine("给定日期在当前日期之后");
}

SELECT IF('2022-01-01' < CURDATE(), '给定日期在当前日期之前', '给定日期在当前日期之后') AS result;

using MySql.Data.MySqlClient;

string connectionString = "server=your_server;user=your_username;password=your_password;database=your_database;";
string query = "SELECT IF('2022-01-01' < CURDATE(), '给定日期在当前日期之前', '给定日期在当前日期之后') AS result;";

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

    using (MySqlCommand command = new MySqlCommand(query, connection))
    {
        using (MySqlDataReader reader = command.ExecuteReader())
        {
            if (reader.Read())
            {
                string result = reader.GetString("result");
                Console.WriteLine(result);
            }
        }
    }
}