Marko
06/23/2021, 8:22 AMtestAt DateTime
testTzAt DateTime @db.Timestamptz
From my understanding timestamp without timezone should store DateTime in the local time, but for what ever reason,
when ever I save this, both of them get converted to UTC:
testAt: '2021-06-24T01:16:14.963+02:00',
testTzAt: '2021-06-24T01:16:14.963+02:00',
When I read the selected row, this is what I get back:
testAt: 2021-06-23T23:16:14.963Z,
testTzAt: 2021-06-23T23:16:14.963Z,
What am I doing wrong here, because currently I don't see any difference here.
Thank you!Orkhan Rustamli
06/23/2021, 8:25 AMMarko
06/23/2021, 9:02 AMINSERT INTO
query to save the same datetime and it saved it correctly (the testAt
didn't convert to UTC automatically). I'll open up a github issueMarko
06/23/2021, 9:16 AM