OracleFunctions and DatetimeOffset

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
jared
Posts: 10
Joined: Wed 12 Oct 2011 22:12

OracleFunctions and DatetimeOffset

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

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.

Post Reply