OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums Forums OroPlatform OroPlatform – How do I? Questions How to configure date filter and timezone?

This topic contains 1 reply, has 2 voices, and was last updated by  asolonenko 6 years, 3 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #36541

    GitDaimos
    Participant

    Hi,
    I have timezone europe/warsaw utc +1, and I have date filter for my grid.
    When I set my filter to date from: 2017-12-02, to: 2017-12-02 (so, one day only) i have query:

    My column have DATE type, and i have correct timezone inside database. Why filter generate 23:00:00 if my timezone is europe/warsaw +1 ?
    If I search for 2017-12-01:

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #36542

    asolonenko
    Participant

    Hello @GitDaimos
    It happens because datetime fields stores in database in UTC, so when you save current datetime in database it will reduce it by one hour before saving.
    And of course it will increase datetime value before showing you in application.

    For DATE fields we’ve created ticket to fix this issue.

    Thanks for request.

Viewing 1 replies (of 1 total)

The forum ‘OroPlatform – How do I? Questions’ is closed to new topics and replies.

Back to top