need help for time zone

[ananyaghosh]

Hi,

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.

Thanks,

Sandip

[Clever_Anjos]

Please try converting to timestamp before

=converttolocaltime(Timestamp#('24-JAN-18 12.00.00.000000000 AM','DD-MMM-YY hh.mm.ss.ffffffffffff TT'))