db2 Date to string in YYYYmmdd

turash · Post by **turash** » Tue Nov 06, 2007 1:40 pm

I am trying the following, does not get desired output
oconv(iconv(DSLink2.CODE_EFF_DATE, "D/MDY[2,2,4]"), "DYMD[4,2,2]")

I need output as YYYYmmdd format.

Thanks in advance!

DSguru2B · Post by **DSguru2B** » Tue Nov 06, 2007 2:12 pm

Try the following

Code: Select all

oconv(iconv(DSLink2.CODE_EFF_DATE, "D/MDY[2,2,4]"), "DYMD[4,2,2]":@VM:"MCN")

turash · Post by **turash** » Tue Nov 06, 2007 2:14 pm

Thanks a lot

DSguru2B wrote:Try the following
Code: Select all
oconv(iconv(DSLink2.CODE_EFF_DATE, "D/MDY[2,2,4]"), "DYMD[4,2,2]":@VM:"MCN") 