Century Boundary
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Attribute
CenturyBoundary (CB)
Purpose
The cutoff year for century inference when converting two-digit dates to four-digit dates.
Valid Values
xx
where:
- xx
- is a two-digit number.
Behavior
Two-digit
dates that are less than the specified year number are converted
to 20xx. Two-digit dates greater
than or equal to the number are converted to 19xx.
For example, using the default value of 20, a date of 19 will be
interpreted as 2019 and a date of 21 is interpreted as 1921.
Default
20