- Data Integration
- All Products
Transformation data type
| Java Data Type
|
---|---|
bigint
| long
|
binary
| byte[]
|
date/time
| BigDecimal
long (number of milliseconds since January 1, 1970 00:00:00.000 GMT)
|
decimal
| double
BigDecimal
|
double
| double
|
integer
| int
|
string
| String
|
text
| String
|
This is missing documentation about date/time type handling. The chart references that it could be exposed as either long or BigDecimal, but there is no explanation of how this would be configured (unlike the "NOTE" entry that does explain this distinction for the decimal type). I see from looking inside IICS it is associated with the "Use Nanoseconds in Date/Time" Advanced setting, and it does explain it in a hover field there. Please add that information to this page.
Hi David Gutteridge,
Thanks for reaching out! We'll verify this information with our development team and update the documentation in an upcoming release.