Y2K38
The Year 2038 problem (also called Y2038 or Y2k38 or Unix Y2K) relates to representing time in many digital systems as the number of seconds passed since 00:00:00 UTC on 1 January 1970 and storing it as a signed 32-bit integer. Such implementations cannot encode times after 03:14:07 UTC on 19 January 2038.
Similar to the Y2K problem, the Year 2038 problem is caused by insufficient capacity used to represent time.
Date values can range from 1-jan-1582 to 31-dec-2382. Time intervals can range from -800(max) years to +800(max) years within the specified range of Date values.
Internal system catalogs and SQL functions are updated to ensure Actian X continues to operate as expected beyond 03:14:07 UTC on 19 January 2038. The SQL functions _date4(), _date(), date_part(), _bintim() now return INTEGER8 instead of an INTEGER4.
Last modified date: 08/22/2022