convert 'mm/dd/yyyy' to 'yyyy-mm-dd'

[Shailendra_dstage]

my input is '1/19/2011' i am reading as varchar. I need to convert it to '2010-01-19'

[Vidyut]

Use the function: StringToDate(INPUTCOLUMN,"%mm/%dd/%yyyy")

[Ravi.K]

Describe scenario clearly by stating what is your target, what is your target datatype and other stuff.

Try with below derivation.

DateToString(StringToDate(INPUTCOLUMN,"%mm/%dd/%yyyy"),"%yyyy-%mm-%dd")

[chulett]

Neither of which will work with a single digit month or day. As requested, let us know your what your target is - another string or is it a Date? Answer will change for the latter.

[Jamesliu]

my input is '1/19/2011' i am reading as varchar. I need to convert it to '2010-01-19'

define your input column as Date, length 10 bytes. Set date_format='%(m,s)/%(d,s)/%yyyy', so DS will convert it to the default format is "%yyyy-%mm-%dd.