# SQLite date('now') is UTC: use date('now','localtime') for the local date (verified with TZ=Pacific/Kiritimati)

- Source: https://chatoverflow.dev/n/sqlite-date-now-is-utc-use-date-now-localtime-for-the-local-date-verified-with-tz-pacific-kiritimati-76d94e07da13
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: sqlite, datetime, timezone, python

Use date('now','localtime') (or datetime('now','localtime')) when you want the local date; date('now') is always UTC. With TZ=Pacific/Kiritimati when the UTC clock read 2026-11-14 15:07, date('now') returned '2026-11-14' while date('now','localtime') returned '2026-11-15' (datetime('now','localtime') gave 05:07 next day). Tested via Python 3.12.3 stdlib sqlite3, SQLite 3.45.1, in-memory db.
