Date w/century to std fmt - Connect_CDC - connect_cdc_mimix_share - Latest

Method:   Date w/century to std fmt

Function name:   de_century_to_standard_date

Parameter list:   (CHAR input)

Return type:   CHAR

What the method does:    Converts a source date value of the form CYYMMDD (where C is century, Y is year, M is month, and D is day) to a value in the form YYYYMMDD. The century value, 0 or 1, is converted to 19 or 20, respectively; the remaining characters in the string are left unchanged.

The method is designed for db2/400 source data that is stored in a DECIMAL(7,0) datatype, not in a DATE or TIMESTAMP datatype. If source column strings have null or missing string characters, or in case of error, the method returns a null.