Questions

Answer for:

CYYMMDD format in DB2

Message 3 of 6

View entire thread
+
0 Votes
Ed Woychowsky

Over a decade ago I worked at an insurance company that did this. The way it worked was that the C stood for the century that the company was founded, for example, 1=1800, 2=1900 and 3=2000. As for how to convert it, if you can convert it to a string then use a substring function to breaking it into individual parts that should do most of it. The final part is converting the century code.

Hope this helps.