Closed
Description
Hi,
When I'm using a where condition such as
.Where("RequestedDate > \"Fri, 10 May 2019 11:03:17 GMT\"")
the output sql query contains:
[RequestedDate] > '2019-05-10T13:03:17.0000000+02:00'
My server is running in CEST timezone and I guess that is why I get +2 hours. However, this behavior is not what I'm after as all dates in my DB are considered to be UTC and clients (browser - javascript) are providing dates always in UTC as well and thus the conversion breaks the functionality.
Is there any way to stop this behavior? Is this behavior intented?
I figured I can just omit the zone and provide Fri, 10 May 2019 11:03:17
, but this format is 'not supported' via native Javascript Date and I would have to remove it manually (which is possible and current workaround I'm using, but it doesn't feel right).
Thank you for any insights you can provide :-)