Questions

Answer for:

CYYMMDD format in DB2

Message 6 of 6

View entire thread
+
0 Votes
Jonathan.Davis

CYYMMDD is an old IBM Date Format.
When C = 0 the Century is 1900
C = 1 the Century is 2000.

An easy way to handle this format is below

INPUTDATE + 19000000

INPUTDATE will now be in CCYYMMDD format.

Sometimes it takes an old programmer to teach new kids tricks.