Hi - is there any way to disable the feature that automatically converts datetime fields into the local server time? I have an application that I’m using which looks at everything in UTC time. I’m doing some testing and although doable it’s pretty annoying to have add back in hours to get the times to match up - or write out to a csv file to check that the actual data is right.
Is there a setting somewhere to turn off it automatically converting datetimes into the local timezone on the server?
Hi pintail
If I understand your issue correctly, you need to set the date field(s) in your metadata to a different timezone (UTC). You can do this in the metadata editor, please see the image below.
Hope this helps.
Thats the issue, but I don’t see the timezone option unfortunately - I only have locale available in the advanced meta options. I might be on an older version? I’m on 3.4. Is there a global setting file I can adjust anywhere in the installation files?
It’s not a huge deal, but would definitely be nicer if I could get it all to be in UTC, or just show the actual data values with no conversions. As a check I’m just writing out the data to a csv file to verify the datetimes look correct (they are all correct and in UTC in the flat file). So more of an extra step/inconvenience than a show stopper…
thanks for any advice, no worries if it can’t be adjusted.
Hi pintail
Unfortunately there is no option to change or disable the time/date conversion for versions prior to 3.5.0. I would recommend you to upgrade. We no longer officially support versions prior to 4.0.0 anyway.
Best regards
