[AccessD] SQL Server times link as str

Thanks Stuart.  I kinda figured I was screwed!  ;)

John W. Colby
www.ColbyConsulting.com

On 4/23/2011 7:05 PM, Stuart McLachlan wrote:
> Time() is a new type in SQL Server 2008.   Are you sure the other field is DateTime and not
> DateTime2 (also new in 2008)?
>
> Basically, you are screwed.  MS in its wisdom decided to pass Time() and DateTime2 to
> "down-level clients" as strings, rather than as the numerics which are used to store them, so
> you will have to parse then back to compatible Access datatypes yourself.
>
> See
> http://msdn.microsoft.com/en-us/library/ms180878%28v=SQL.100%29.aspx#BackwardCom
> patibilityforDownlevelClients
>
> "Some down-level clients do not support the time, date, datetime2 and datetimeoffset data
> types added in SQL Server 2008. The following table shows the type mapping between an
> up-level instance of SQL Server 2008 and down-level clients."
>