Datetime issues when Postgres database has a timezone set. about bracket HOT 3 CLOSED

Thanks for opening the issue.

What is the advantage of changing datetime_utc to datetime_tz? And why not just set your database's timezone to UTC?

I don't think changing datetime_utc to datetime_tz is a good idea, because it adds complexity and hides which timezone is actually used. Bracket already writes in the same timezone as it reads (UTC), so there shouldn't be a reason to use something other than UTC. In the end, postgres uses UTC internally anyway. If there really would be a usecase, it would be better to convert timezones when reading/writing to the database.

from bracket.

My database is set to my local timezone just because it is. I think setting to UTC is probably the easiest fix, especially when it comes to setting timezones in docker.

from bracket.

I have my datetimes stored in Europe/London still, maybe the schema should be timestamp instead of timestamptz? Although I am not sure how that would be set with the ORM.

Edit: only set it for the session, after changing the config it works now.

from bracket.