type conversion

laxmi_etl · Post by **laxmi_etl** » Tue Mar 13, 2007 10:30 am

Hi,

I am reading from a file and writing to another file.
One of the fields need a string to date conversion I used the function
String To Date conversion in the Transformer.
When I use it it's giving out put ***** manner.

What is the reason for it?

Input data is 20061203 format output I need to get 2006-12-03.

But most of the records has 00000000 values in that field.
So I tried to give values to the null but that one also not working for
it

Is there any suggestions.

Thanks

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 10:39 am

What is the derivation that you are providing? Post all methods you have tried, specifically the format you are giving for the conversion.

laxmi_etl · Post by **laxmi_etl** » Tue Mar 13, 2007 10:43 am

StringToDate(DSLink9.A,"%yyyy-%mm-%dd")

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 10:46 am

Provide

Code: Select all

StringToDate(DSLink9.A,"%yyyy%mm%dd")

laxmi_etl · Post by **laxmi_etl** » Tue Mar 13, 2007 11:56 am

In one way it's working.

I mean if the record has 20060303 that function is working
If the value is in 00000000 then it is giving **** value

laxmi_etl · Post by **laxmi_etl** » Tue Mar 13, 2007 12:01 pm

If the record has 00000000 value in that field that I am supposed to conver to date then I have given the fallwoing function.

If IsNull(DSLink9.A) Then 0 Else (StringToDate(DSLink9.A,"%yyyy%mm%dd"))

but it is giving fallowing error while compiling.
Invalid conversion requested while converting int8 to date

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 12:05 pm

Becuase 000000 is not null. Look for '00000000', if found, set to null, else apply the StringToDate() function.

laxmi_etl · Post by **laxmi_etl** » Tue Mar 13, 2007 12:57 pm

It is working.

Thanks

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 1:09 pm

Great. Mark the post as resolved then.