[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:


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


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