Data lake datetime fields

I am trying to retrieve a datetime field from a data lake "table" but I get three different answers depending on how I retrieve the results.

Compass	2023-04-26T16:42:01.630Z
AppEng via Windows	2023-04-27T02:42:01Z
AppEng via Web	2023-04-26T04:42:01Z

I am in the UTC+10 hours time zone which would explain the AppEng via Window result. The AppEng via Web is substracting 12 hours which doesn't make sense. The customer is in UTC+12 hours but this is MT-Tenant site so I would not have thought it would not make any difference.

On another field I get this.

Compass	2023-04-26T00:00:00.000Z
AppEng via Windows	2023-04-26T10:00:00Z
AppEng via Web	2023-04-26T12:00:00Z

So the AppEng via Window is at least consistent with the previous results but the AppEng via Web is plus 12 hours.

Can anyone explain this one, and more importantly I how can I retrieve the same results as Compass via Application Engine?

Find more posts tagged with

Infor EPM Discussions

Comments

unknown

Hi @peter-mayall ,

Compass stores and displays the date time in UTC. If you call an AppEngine from the Process Editor, it takes into account your local settings and adjusts the time accordingly. The timezone of the Web is determined for the tenant and is usually set according to the customer's need.

That said, the second case behaves as expected.

The first case seems to me suspicious. I would expect there 27th of April.

If there is an obvious reason explaining that, I would recommend reaching our support.

Best,

Standa

Peter Mayall

Thanks Standa, that confirms my suspicions.

Would anyone know how to get AppEngine to read the datetime fields without adjusting for local settings? I am using the SQLDataRowGetDateTime function to read the field.

It should be possible to work out the timezone within the AppEngine routine but it rather awkward to have to manipulate the datetime fields like this.

ivan-rebo

I think this is simply a bug. The value should be given to you in UTC. I think it if you try the same with SQL server or other connection it will work properly there and its only broken for DataLake. Could you please also confirm that if you make a list with the datetime value in app studio it also shows wrong time zone?

Copyright © 2025 Infor. All rights reserved.