I have a field with TIMESTAMP with TIMEZONE format and using the below syntax in the sql code:
CAST(FROM_TZ(CAST(a1.PROCSTART_DATE_TIME AS TIMESTAMP), 'UTC') at time zone 'America/New_York' AS Timestamp)
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:
=converttolocaltime(converttolocaltime('24-JAN-18 12.00.00.000000000 AM','UTC'),'Eastern Time (US & Canada)',true())
unfortunately it gives me nothing. Please suggest what is wrong here.