Hi
According to the documentation, Infor Data Lake stores timestamps in UTC, and consuming applications are expected to convert them back to local time where required.
When uplifting an on-premises SQL Server database (with timestamps stored in the local time zone) using the ION Data Loader, the timestamps are loaded as-is and are not converted to UTC during ingestion.
Is this the expected behaviour of the ION Data Loader?
If so, is it required that timestamps be normalized in a view for every table before ingestion, either by:
- converting them to UTC
- supplying timestamps with an explicit offset (e.g.
2025-06-30 21:15:18.000 +10:00)?
I just want to confirm whether one of these approaches is expected when using the Data Loader, or if there is an alternative ingestion-time handling of time zones.
Regards
