One Star

[resolved] Convert date to string use tConvertType

I have this structure
tDatabase-tConvertType
I take the schema and if i modified the schema of tConvertType for example
database          convertType
id int               id change to String
date date        date date
all is correct
but if i try
id int          id int
date date   date try to change to string
I have error how i can convert string to date?
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] Convert date to string use tConvertType

I tried in same way as you mentioned it's working fine 
tconverttype component schema 
Checkout attached screenschots

2 REPLIES
Seventeen Stars

Re: [resolved] Convert date to string use tConvertType

I do not know why but in a scenario like this Date->String the auto cast function does not return a value. But if you use explicit cast it works well. The Date will be converted into a string using the Date pattern from the input schema.
One Star

Re: [resolved] Convert date to string use tConvertType

I tried in same way as you mentioned it's working fine 
tconverttype component schema 
Checkout attached screenschots