Hello gurus

I am stuck with an date conversion issue, the field in the table is
decimal(8) and it has date in yymmdd format(not YYYYMMDD) .

As of now I am trying to use

DATE(TRANSLATE('20CD-EF-GH',DIGITS(date_closed),'ABCDEFGH')) but this
will make the date to start with year 2000.

Example

If date_closed = 980201

DATE(TRANSLATE('20CD-EF-GH',DIGITS(date_closed),'ABCDEFGH')) will
produce

02/01/2098

Which is wrong .Can any one suggest a better and a correct way


Thanks
-Raj



LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.
[ST:XCL]





DB2 & UDB email list listserv db2-l LazyDBA home page