Timezone file version 46 for the latest daylight saving rule change for BC
The upcoming daylight saving rule change for British Columbia in Canada will permanently remove twice-yearly clock changes. On November 1, 2026, we no longer fall back 1 hour . Does the latest Quarterly patchset RU for Oracle 19c database including this?
I don't see the latest timezone file version 45 including this. Below is my testing for our current database using verion 45:
SQL> SELECT * FROM v$timezone_file;
FILENAME VERSION CON_ID
timezlrg_45.dat 45 0
SQL> SELECT
FROM_TZ(TIMESTAMP '2026-11-15 12:00:00', 'America/Vancouver') AS local_time,
FROM_TZ(TIMESTAMP '2026-11-15 12:00:00', 'America/Vancouver') AT TIME ZONE 'UTC' AS utc_equivalent,
FROM_TZ(TIMESTAMP '2026-10-30 12:00:00', 'America/Vancouver') AS local_time_old,