如何将MS SQL Date或DateTime转换为OADate？

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "SELECT YourDateColumn FROM YourTable";

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

            SqlCommand command = new SqlCommand(query, connection);
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                DateTime date = (DateTime)reader["YourDateColumn"];
                double oadate = date.ToOADate();

                Console.WriteLine("MS SQL Date: {0}", date);
                Console.WriteLine("OADate: {0}", oadate);
            }

            reader.Close();
        }
    }
}