I encountered this bug when using EF.Functions.DateDiffSecond in a nested query. DATEDIFF(second, [w1].[StartedAt], [w1].[CompletedAt]) to work properly. It also ...