Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert date time zone?

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)?

1 Solution

Accepted Solutions
Not applicable
Author

The ConvertToLocalTime function should do the trick.

View solution in original post

3 Replies
Not applicable
Author

The ConvertToLocalTime function should do the trick.

Not applicable
Author

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;

Not applicable
Author

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