You are currently reviewing an older revision of this page.
The CONVERT_TZ() function returns NULL in phpMyAdmin when using timezone names, such as SELECT CONVERT_TZ(NOW(),'US/Eastern','Europe/Paris');.
CONVERT_TZ()
NULL
SELECT CONVERT_TZ(NOW(),'US/Eastern','Europe/Paris');
The MySQL timezone tables have not been populated, as described in the documentation.
This product use case has been logged to the Appian Product Team for consideration to add this functionality in the product. Kindly note it is not Appian Support’s policy to disclose how or when a product use case will be implemented.
If you are facing this issue and would like to be added to the existing product use case (#1391 - Populate time zone tables in Appian Cloud MySQL database), please open a support case with Appian. Meanwhile, Appian Support strongly recommends that you transition to the following approach as a best practice:
Date/time values stored in the database should always be in GMT/UTC. Any conversion to the local timezone should be handled in the presentation layer (our UI layer already handles converting data/time values to the local timezone). If you have a use case to convert a user input, you should consider using a web API (these will be current). For example, Google has the following API.
This article applies to all versions of Appian Cloud.
Last Reviewed: June 2020