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

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

Parents
  • Hi,
    1. Firstly, check the time zone settings in the admin console if it set correctly or not. In the latter case, the function you are using on the interface to call date might cause the issue. While retrieving the data, try validating using functions local(), text() to get the output in desired format.
    2. Also, in the process model properties, select the appropriate timezone and check the box "Override initiators timezone".
    For reference please check - community.appian.com/.../handling-date-and-time

    Thanks.
Reply
  • Hi,
    1. Firstly, check the time zone settings in the admin console if it set correctly or not. In the latter case, the function you are using on the interface to call date might cause the issue. While retrieving the data, try validating using functions local(), text() to get the output in desired format.
    2. Also, in the process model properties, select the appropriate timezone and check the box "Override initiators timezone".
    For reference please check - community.appian.com/.../handling-date-and-time

    Thanks.
Children
No Data