[tz] DST ends 2040 in Oracle database

Paul Eggert eggert at cs.ucla.edu
Fri Jan 25 19:46:39 UTC 2019


Although tzdb's traditional .zi (text) files for New York have no expiration 
date, its traditional TZif (binary) format was limited to signed 32-bit 
timestamps and so stopped working after 2038. As Brian Inglis noted here:

https://mm.icann.org/pipermail/tz/2019-January/027431.html

the TZif year-2038 problem was fixed in 2006. However, as Sergiusz Wolicki noted 
here:

https://mm.icann.org/pipermail/tz/2019-January/027432.html

the Oracle compiler stops at 2040, inspired by the earlier TZif limit. So if you 
need to predict timestamps past 2040 you'll need to fix the Oracle compiler, or 
use some other compiler to translate the .zi files.


More information about the tz mailing list