Skip to content

Timezone conversion #268

Closed
Closed
@Enngage

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 :-)

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions