Sql Server, datetimeoffset datatype, which driver should i use?

Data Abstract
1

Connecting to Sql Server 2008 with the MSSQL.NET, driver using the latest DataAbstract 6.0.61.1033.
I cannot import fields with datetimeoffset datatype (they don’t show up in the data explorer).

Which alternatives do I have if I wish to expose datetime with timezone information in my schema?

2

Hello.

Sorry for the belated response.
The problem has been reproduced. Appropriate issue is registered as #57830 “MSSQL driver doesn’t recognize datetimeoffset datatype fields.”.

Thanks.

3

Thanks for checking!

So we wait with datetimeoffset datatype. Any idea when this might get implemented?
I see the odbc driver maps this field into datatype datWidestring when added to the schema. Is this the datatype that makes most sense or will there be a new datatype for datetime with timezone information?

4

Hello.

Unfortunately, I can’t say deadline for this problem as it requires some investigation work: datetimeoffset type must be added not only to Schema Modeler but to DataAbstract for .NET and DataAbstract for Delphi. Nowadays I can advice to store datetime value and timezone offset in separate fields and use standard functions to convert datetime value to datetimeoffset value.

Thanks.