Kuba Petržílka02/15/2021, 8:37 AM
in postgres I used
from Java Time API extension for Exposed) and when I persist a record it uses my current timezone, but I would like to get it persisted in GMT so that I dont have to do that math when comparing the values while looking into the DB (I want
) how do I enforce this?
spand02/15/2021, 9:28 AM
Kuba Petržílka02/15/2021, 9:39 AM
method in a configuration class (I m using spring boot) and it doesn't seem to have any effect
Joel02/16/2021, 4:57 PM
specifically yet. The effect you're seeing is probably related to serialization of the data. See here, my guess is your db is assigning the default timezone.
Kuba Petržílka02/16/2021, 5:48 PM
And the suggestion to change the default timezone doesn't work in my case.. but I think it is not a good option anyway.. I d like to choose which timezone I want to use per record not globaly per system ... so Exposed really lacks this support
Joel02/16/2021, 6:58 PM
spand02/16/2021, 8:32 PM
to the database. I cant see any way around that other than maybe having something per dialect that sets the zone per connection.
Kuba Petržílka02/17/2021, 2:49 PM