For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi there,
I'm trying to get a way to come back to eBS menu from APEX without having to login again. Any idea how to handle?
Thanks in advance.
It could be a bug. Do you have test case to help us better understand the problem with TimeOfDay that you experience?
Sorry for the delay. I can't use TimeOfDay as in the example below:
var ts1 = new TimeSpan(6, 10, 0); var ts2 = new TimeSpan(6, 50, 0); var x = from t in TestTable where t.DtColumn.Value.TimeOfDay >= ts1 && t.DtColumn.Value.TimeOfDay <= ts2 select t; x.Dump();
Instead, I have to run the query separately (hours and minutes):
from t in TestTable where (t.DtColumn.Value.Hour >= 6 && t.DtColumn.Value.Minute >= 10 ) && (t.DtColumn.Value.Hour <= 6 && t.DtColumn.Value.Minute <= 50 ) select t
I am attaching a sample table and you can use LinqPad to test the query. export.txt (130.51 KB)
Thanks for reporting. I filed bug 32388939 to track this issue. We'll take a look at it.
This bug was fixed, but missed making it into the first Oracle EF Core 5 release. The fix will be part of the next Oracle EF Core 5 release.
Thank you!