Date format conversion: YYYY-MM-DD to YYYYMMDD

durgaps · Post by **durgaps** » Tue Sep 19, 2006 6:59 pm

Hi,

I need to convert a Date input column having format YYYY-MM-DD to output as YYYYMMDD. I tried Oconv(Iconv(DSLink3.date1,"D-YMD"),"DYMD") but the output is coming as YYYY MM DD. How can I achieve my original desired results? I searched through the DS Help but couldnt find a solution for this.

Thanks,

kumar_s · Post by **kumar_s** » Tue Sep 19, 2006 7:06 pm

What is the output datatype. If it is char/varchar, juct Convert '-' to ''

DSguru2B · Post by **DSguru2B** » Tue Sep 19, 2006 10:40 pm

or you can use the following code

Code: Select all

Oconv(Iconv(InLink.Date, "DYMD[4,2,2]"), "DYMD[4,2,2]":@VM:"MCN")

OR

Code: Select all

DIGITS(InLink.Date)

Xpert · Post by **Xpert** » Wed Sep 20, 2006 12:28 am

Hi,

You can use DIGITS(DSLink3.Date), it works fine than Oconv and Iconv conversion.