Function setUTCTimeZone

server-source-code/internal/database/db.go:191–199

setUTCTimeZone pins the session TimeZone to UTC for every connection in the pool. Our created_at/updated_at columns are TIMESTAMP (without time zone). Postgres converts NOW()/CURRENT_TIMESTAMP (timestamptz) into the session's local wall clock when inserting into such columns, while pgx reads them ba

(poolCfg *pgxpool.Config)

// Forcing the session to UTC keeps store and read consistent so relative-time
// formatting on the frontend doesn't drift by the DB host's TZ offset.
func setUTCTimeZone(poolCfg *pgxpool.Config) {
	if poolCfg == nil || poolCfg.ConnConfig == nil {
		return
	}
	if poolCfg.ConnConfig.RuntimeParams == nil {
		poolCfg.ConnConfig.RuntimeParams = map[string]string{}
	}
	poolCfg.ConnConfig.RuntimeParams["TimeZone"] = "UTC"
}