Date Conversion problem: Date == 2079/12/31

Raymond Hettinger python at
Mon Aug 19 17:44:54 CEST 2002

"Bradley D. Larson" wrote
> Fourth Shift utilizes 2079/12/31 as the "end of time" for items that
> do not expire.  Unfortunately the python "time" lib does not handle
> this date.  I have attempted to convert the date to something else
> in the sql call (eg. to_date(out_date,'YYYYMMDD')) but this does
> not appear to be supported in the Fourth Shift ODBC/DB calls.
> Does anyone know if this date is pushed back farther in python 2.2?
> Or do you know of a work around...

Hye-Shik Chang wrote a patch to that expands the
date range.  See

Raymond Hettinger

More information about the Python-list mailing list