Date Conversion
Posted: Wed Apr 06, 2005 10:50 pm
Hi ,
I have a col of char '8' and another of char '10'. Using stringToDate() function I'm trying to convert these columns to a date, with the default date format. But it's not working. The job is getting aborted.
Well I'm putting following in the derivation
StringToDate(inData.Date1) -- and trying to store it in the Date , data type column.The i/p data is in the YYYYMMDD format and I want the same in the o/p so I'm not giving any format string.
Can anybody plz tell me , what mistake I'm doing?
Thanks.
I have a col of char '8' and another of char '10'. Using stringToDate() function I'm trying to convert these columns to a date, with the default date format. But it's not working. The job is getting aborted.
Well I'm putting following in the derivation
StringToDate(inData.Date1) -- and trying to store it in the Date , data type column.The i/p data is in the YYYYMMDD format and I want the same in the o/p so I'm not giving any format string.
Can anybody plz tell me , what mistake I'm doing?
Thanks.