Hello FDMEE Admins,
We have a script in place (Jython) which is getting the date from the table TLOGPROCESS, specifically the field PROCESSENDTIME. We convert this to an integer. Then load this value via a logic account.
We have noticed that the value being loaded is not the same as the one which is shown in the data audit or the one in the FDMEE process details.
Could the reason be that the convert is actually being done based on where the user is located? So if I have a number of 42799 as a value and I convert back to date, it will give me a different date time here in Switzerland than in say Australia?
SELECT convert(int, p.PROCESSENDTIME)+1 as ImportTimeStamp
FROM TLOGPROCESS p
Thanks a lot for your feedback
Roman