darkeagle76

Hello, I think the problem is related to the conversion from DateTimeOffet to DateTime, see the method DateTimeOffsetToDateTime in the class [ExpressionBinderHelper](https://github.com/OData/AspNetCoreOData/blob/main/src/Microsoft.AspNetCore.OData/Query/Expressions/ExpressionBinderHelper.cs#L653). It calls the method [EdmPrimitiveHelper.ConvertPrimitiveValue](https://github.com/OData/AspNetCoreOData/blob/main/src/Microsoft.AspNetCore.OData/Edm/EdmPrimitiveHelper.cs#L25) to convert from...

I'm also see the problem. Please check the [description](https://github.com/OData/AspNetCoreOData/issues/378#issuecomment-1672782754) I provided in the issue #378. Any suggestion? Thanks D

@pgrimmert My original problem is not related to postgres but thanks for the hint! I see you also saw my [PR](https://github.com/OData/AspNetCoreOData/pull/1033)... I hope someone will approve it soon. Thanks!

> With this modification we would avoid getting a DateTime value (derived from a conversion from a DateTimeOffset value) that has Kind=Unspecified. The problem is mainly evident when passing Dates...