Connecting to a non-Appian managed database table and getting incorrect date & time

Question

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

Umesh Patel · Accepted Answer

Hi Richard, 
I am thinking little loud, please validate if its possible in your case. 
Is it possible to create DB view with derived field of date which does this task of converting from local time to GMT. 
Your Query Entity should point to this DB View instead of table. 
Thanks.

Robert Shankin · Answer

Umesh Patel beat me to it! 
I would also make the view that offsets the time to GMT.

Richard · Answer

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.