Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)?
The ConvertToLocalTime function should do the trick.
The ConvertToLocalTime function should do the trick.
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;
Thanks. I just tested it and it looks to have worked!