Question
November 11, 2008 at 02:35 AM
pravins.s

CYYMMDD format in DB2

by pravins.s . Updated 17 years, 3 months ago

I have a date format in db2 which has a date in
the below format. CYYMMDD in which the C stands
for century, YY for year, MM for month and DD
for day. Right now am storing it as string. for
example, 1082702. How to convert this string to
date? I want to find the diference between the
dates which are in the above format. Please
help.

This discussion is locked

All Comments