DevOps, CI/CD and Automation

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.

Thank you!