I'm accessing a database belonging to another tool. In order to retrieve certain data items we've constructed a data type and a data store and are using query Entities to retrieve information. However, this system stores date and time values in the local time of the users of the application.
Unfortunately, when I retrieve them into Appian, it treats all the values as if the value was stored in GMT and presents it to me as if it was in my timezone when displayed.
Is there a simple way to convert the data back to the original timezone?
R
Discussion posts and replies are publicly visible
Can you derive the timezones from the dates in the other system? Then can you use gmt() and local() to have the results display differently inside your application?
I think these two comments constitute a good answer to the problem. Thank you both!Creating a view to manage the date / time conversion to GMT from the native format would solve the problem.I do wish, sigh, that Appian would allow us the ability to manage date/times ourselves by overriding the default behaviour, though.