[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