Page 1 of 1
OracleFunctions and DatetimeOffset
Posted: Tue 27 Mar 2012 20:28
by jared
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?
Posted: Wed 28 Mar 2012 13:36
by Shalex
The OracleFunctions.SysExtractUtc(DateTimeOffset?) overload is added. We will post here when the corresponding build of dotConnect for Oracle is available for download.
Posted: Thu 29 Mar 2012 16:21
by Shalex
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.