topic Convert date time zone? in QlikView https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231474#M83211 <HTML><HEAD></HEAD><BODY><P>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)?</P></BODY></HTML> Tue, 04 May 2010 21:25:54 GMT 2010-05-04T21:25:54Z Convert date time zone? https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231474#M83211 <HTML><HEAD></HEAD><BODY><P>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)?</P></BODY></HTML> Tue, 04 May 2010 21:25:54 GMT https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231474#M83211 2010-05-04T21:25:54Z Convert date time zone? https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231475#M83212 <HTML><HEAD></HEAD><BODY><P>The ConvertToLocalTime function should do the trick.</P></BODY></HTML> Tue, 04 May 2010 21:41:36 GMT https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231475#M83212 2010-05-04T21:41:36Z Convert date time zone? https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231476#M83213 <HTML><HEAD></HEAD><BODY><P>Thanks. I'm trying this now. But just to be clear:</P><P>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?</P><P>LOAD ConvertToLocalTime(gmt_date) AS date;<BR /> SQL SELECT date AS gmt_date FROM otherdatasource;</P><P></P></BODY></HTML> Tue, 04 May 2010 21:47:40 GMT https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231476#M83213 2010-05-04T21:47:40Z Convert date time zone? https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231477#M83214 <HTML><HEAD></HEAD><BODY><P>Thanks. I just tested it and it looks to have worked!</P></BODY></HTML> Tue, 04 May 2010 21:49:16 GMT https://community.qlik.com/t5/QlikView/Convert-date-time-zone/m-p/231477#M83214 2010-05-04T21:49:16Z