Access ODBC驱动程序中无效的日期时间格式异常

考虑到更新后的问题中的测试数据，以下变通办法似乎可以正常工作。它检查

.Driver

Date/Time

Double

System.DateTime

datetime

（请注意，此特定方法

使用`rdr[0]) * 86400`''对于Access中早于的值（即，当值为负时） **将无法**正常工作。）`Date/Time

`Double

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.Odbc;namespace odbcTest{    class Program    {        static void Main(string[] args)        { using (OdbcConnection con = new OdbcConnection()) {     //con.ConnectionString =     //        @"Driver={SQL Server};" +     //        @"Server=(local)SQLEXPRESS;" +     //        @"Database=myDb;" +     //        @"Trusted_connection=yes;";     con.ConnectionString =  @"Driver={Microsoft Access Driver (*.mdb, *.accdb)};" +  @"Dbq=C:__tmpdateTestTestSqlRead.accdb;";     con.Open();     using (OdbcCommand cmd = new OdbcCommand())     {         DateTime dtm;         var accessTime0 = new DateTime(1899, 12, 30);         bool fromAccess = (con.Driver == "ACEODBC.DLL");         cmd.Connection=con;         if (fromAccess)  //cmd.CommandText = "SELECt DateTimeCol FROM MyTable";  // this fails  cmd.CommandText = "SELECt {fn CDbl(DateTimeCol)} FROM MyTable";         else  cmd.CommandText = "SELECt sqlDate FROM Table1 WHERe ID = 1";         OdbcDataReader rdr = cmd.ExecuteReader();         rdr.Read();         if (fromAccess)  dtm = accessTime0.AddSeconds(Convert.ToDouble(rdr[0]) * 86400);         else  dtm = Convert.ToDateTime(rdr[0]);         Console.WriteLine(dtm.ToString());         rdr.Close();     }     con.Close(); } Console.WriteLine(); Console.WriteLine("Done."); Console.ReadKey();        }    }}