DataType config

[Former Member]

Hi,

do you know if I can change the format of the Date and Time (i.e from yyyy/mm/dd to yyyymmdd) when creating DataType? I know that I can do it in the mapping but I'm not gonna make any mapping for this so that's why I want to do it in DataType.

Maybe in the detail column in "pattern" or "enumeration"?

Thanks

[Former Member · Accepted solution]

No, its not possible.

Regards,

Sarvesh

[Former Member · Accepted solution]

ok thanks,

another question about DataTypes.

when I choose Type: Decimal. Do I put the total of the lenght in Totaldigits and the number of decimals in FractionDigits?

[Former Member · Accepted solution]

> when I choose Type: Decimal. Do I put the total of the lenght in Totaldigits and the number of decimals in FractionDigits?

Can you elaborate your question with example. If you are thinking by mentioning the type and length in Data type then in any case it will not work. You have to use mapping for doing formatting.

Otherwise just using the Data Type as "String" will take care of everything. Eg. if your value comes like 1234.99 then it will be taken care by type string.

[Former Member · Accepted solution]

Hi ,

Total numberof digits in the totaldigits and the fraction in the fraction digits

eg 12345.678

total digits = 9

fraction =3

Regards,

Jude