Skip to Main Content
Forums

ODP.NET

Announcement

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.

EFCore with query comparing Time

mariohikDec 11 2020

Using EFCore, how can I compare just the time of a timestamp?
SELECT * FROM MY_TABLE WHERE TO_CHAR(TIMESTAMP_COLUMN, 'hh24:mi') >= '06:00' AND TO_CHAR(TIMESTAMP_COLUMN, 'hh24:mi') <= '06:05'
I have the Timestamp translated do DateTime, but I can't call .TimeOfDay to do this comparison.
This post has been answered by Alex Keh-Oracle on Feb 12 2021
Jump to Answer

Comments

Alex Keh-Oracle

It could be a bug. Do you have test case to help us better understand the problem with TimeOfDay that you experience?

mariohik

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)

Alex Keh-Oracle

Thanks for reporting. I filed bug 32388939 to track this issue. We'll take a look at it.

1 person found this helpful
Alex Keh-Oracle
Answer

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.

Marked as Answer by mariohik · Feb 12 2021
mariohik

Thank you!

1 - 5

Post Details

Added on Dec 11 2020
#odp-net
5 comments
193 views