nextcloud/lib/private/DB/Middleware
Ferdinand Thiessen 691aedd13e
fix(db): set session timezone to UTC
Some (well all except sqlite) database platforms support timezone
configuration. The problem is that we expect everything in UTC,
but some servers might have set some different default (e.g. in database
configuration or even just because of `TZ` environment variable).

This causes incorrect values when expecting `NOW()` to return the
current time in UTC.

For PHP we already enforce UTC as timezone, this PR adds a middleware
that enforces UTC also as the database connection / session timezone.

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>
2026-04-01 13:47:03 +02:00
..
UtcTimezoneMiddleware.php fix(db): set session timezone to UTC 2026-04-01 13:47:03 +02:00
UtcTimezoneMiddlewareDriver.php fix(db): set session timezone to UTC 2026-04-01 13:47:03 +02:00