OracleFunctions and DatetimeOffset

OracleFunctions and DatetimeOffset

Postby 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?
jared
 
Posts: 10
Joined: Wed 12 Oct 2011 22:12

Postby 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
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44

Postby 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.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle