table = {{ID1, SQLDateTime[{1978, 1, 10, 0, 0, 0.`}]}, {ID2, SQLDateTime[{1999, 1, 10, 0, 0, 0.`}]},
I have a Postgres DB running 7.4 (Yeah we\'re in the midst of upgrading) I have four separate queries to get the Daily, Monthly, Yearly and Lifetime record counts
am passingdefault dates (startdate & enddate)开发者_运维技巧 to an sp as (\'1/1/1753 12:00:00 AM\' & \'12/31/9999 12:00:00 AM\').
I get an SqlDateTime overflow error (Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.) when doing an INSERT using an Linq DataContext connected to SQL Server database when I do the Sub
While converting .NET DateTime (开发者_开发知识库when is default(DateTime)) to SqlDateTime should I always check if the .NET date is between SqlDateTime.MinValue and SqlDateTime.MaxValue [or] Is there