Date Format Conversion

kumar3846 · Post by **kumar3846** » Tue Sep 05, 2006 11:03 am

Hi All,

I have date fromat type yyyy-mm-dd

but i have to convert it to mmddyyyy fromat

the version 7.5.2 EE parallel

pls help me out this

thank you

kumar

thumsup9 · Post by **thumsup9** » Tue Sep 05, 2006 11:52 am

vardate=(TO_CHAR(DATE, 'YYYY-MM-DD'), 6, 2):(TO_CHAR(DATE, 'YYYY-MM-DD'), 9, 2):(TO_CHAR(DATE, 'YYYY-MM-DD'), 1,4)

and then convert this back to Date

TO_DATE(vardate,'MMDDYYYY')

kumar3846 · Post by **kumar3846** » Tue Sep 05, 2006 12:27 pm

we have to do this in transformer or modify stage

meena · Post by **meena** » Tue Sep 05, 2006 12:47 pm

I think it is in SQL.

kumar3846 wrote:we have to do this in transformer or modify stage

kumar3846 · Post by **kumar3846** » Tue Sep 05, 2006 12:52 pm

could you pls help me out how to do this in DS

Thank You

thumsup9 · Post by **thumsup9** » Tue Sep 05, 2006 2:51 pm

vardate= DateToString(Date,'YYYY-MM-DD') and then

StringToDate(((vardate)[6, 2]:(vardate)[9,2]:(vardate)[1,4]),'DDMMYYYY')

HTH