OracleFunctions and DatetimeOffset

jared · Post by **jared** » Tue 27 Mar 2012 20:28

Is there any way to use OracleFunctions with DatetimeOffset data type? I am using EF Code First and my model uses DatetimeOffset, and that is translated to TIMESTAMP(6) WITH TIME ZONE I then put an index on that column and it defines the index as SYS_EXTRACT_UTC("DbCreated"), so i want to be able to use the index by calling OracleFunctions.SysExtractUtc, but it does not support DatetimeOffset (that I can see)...

Any help?

Shalex · Post by **Shalex** » Wed 28 Mar 2012 13:36

The OracleFunctions.SysExtractUtc(DateTimeOffset?) overload is added. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Shalex · Post by **Shalex** » Thu 29 Mar 2012 16:21

New build of dotConnect for Oracle 6.80.332 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).

This build includes the OracleFunctions.SysExtractUtc(DateTimeOffset?) overload.