DSXchange

Shailendra_dstage wrote: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.

I am using Sequential File stage (read from a text file) to read a varchar field with hex value like '0000CF' into an integer field. This works good in DS 7.5, but not work in 8.1. Anyone knows what caused it and how to fix?

Thanks!