topic need help for time zone in QlikView https://community.qlik.com/t5/QlikView/need-help-for-time-zone/m-p/7688#M792040 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a field with TIMESTAMP with TIMEZONE format and using the below syntax in the <STRONG>sql code</STRONG>:</P><P></P><P><STRONG>CAST(FROM_TZ(CAST(a1.PROCSTART_DATE_TIME AS TIMESTAMP), 'UTC') at time zone 'America/New_York' AS Timestamp)</STRONG></P><P></P><P>but I want to just use the filed in the sql and want to convert the time zone in QLIK side instead of at SQL side. So I have used the below code in QLikSense:</P><P><STRONG>=converttolocaltime(converttolocaltime('24-JAN-18 12.00.00.000000000 AM','UTC'),'Eastern Time (US &amp; Canada)',true())</STRONG></P><P><STRONG><BR /></STRONG></P><P>unfortunately it gives me nothing. Please suggest what is wrong here.</P><P></P><P>Thanks,</P><P>Sandip</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ananyaghosh 2020-11-25T16:16:04Z need help for time zone https://community.qlik.com/t5/QlikView/need-help-for-time-zone/m-p/7688#M792040 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a field with TIMESTAMP with TIMEZONE format and using the below syntax in the <STRONG>sql code</STRONG>:</P><P></P><P><STRONG>CAST(FROM_TZ(CAST(a1.PROCSTART_DATE_TIME AS TIMESTAMP), 'UTC') at time zone 'America/New_York' AS Timestamp)</STRONG></P><P></P><P>but I want to just use the filed in the sql and want to convert the time zone in QLIK side instead of at SQL side. So I have used the below code in QLikSense:</P><P><STRONG>=converttolocaltime(converttolocaltime('24-JAN-18 12.00.00.000000000 AM','UTC'),'Eastern Time (US &amp; Canada)',true())</STRONG></P><P><STRONG><BR /></STRONG></P><P>unfortunately it gives me nothing. Please suggest what is wrong here.</P><P></P><P>Thanks,</P><P>Sandip</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/need-help-for-time-zone/m-p/7688#M792040 ananyaghosh 2020-11-25T16:16:04Z Re: need help for time zone https://community.qlik.com/t5/QlikView/need-help-for-time-zone/m-p/7689#M792041 <HTML><HEAD></HEAD><BODY><P>Please try converting to timestamp before</P><P>=converttolocaltime(Timestamp#('24-JAN-18 12.00.00.000000000 AM','DD-MMM-YY hh.mm.ss.ffffffffffff TT'))</P></BODY></HTML> Fri, 26 Jan 2018 13:27:50 GMT https://community.qlik.com/t5/QlikView/need-help-for-time-zone/m-p/7689#M792041 Clever_Anjos 2018-01-26T13:27:50Z