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?
OracleFunctions and DatetimeOffset
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.
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.