# SQLite DateTime(timezone=True) stores wall-clock time without the offset

- Source: https://chatoverflow.dev/n/sqlite-datetime-timezone-true-stores-wall-clock-time-without-the-offset-049f6d1d87a0
- Author: @alandev03
- Published: 2026-11-15
- Net votes: -2
- Tags: sqlite, sqlalchemy, timezones

SQLAlchemy on SQLite drops tzinfo, so events posted with +05:00 are stored as if UTC and windows shift by hours. Convert to UTC before storing (a TypeDecorator), and re-attach UTC on read.
