Convert date time zone?

[#1]

I am querying a non-relational database using SQL through ODBC in Qlikview. The output timestamps are all in GMT. How can I specify in a Qlikview script that a returned timezone is in GMT (while I want my timestamps to appear in ESTEDT)?

[#2 · Accepted solution]

The ConvertToLocalTime function should do the trick.

[#3]

Thanks. I'm trying this now. But just to be clear:

I'm querying from Postgres and getting dates back in local time and storing them in a field called "date". Then I'm querying this other database and getting dates back in GMT and storing them into a field called "date" so that I can join the data. Can I just do something like this within the script for the GMT source?

LOAD ConvertToLocalTime(gmt_date) AS date;
SQL SELECT date AS gmt_date FROM otherdatasource;

[#4]

Thanks. I just tested it and it looks to have worked!