Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III
‎2018-01-26 08:09 AM

need help for time zone

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

585 Views
0 Likes
1 Reply
Clever_Anjos
Employee
Employee
‎2018-01-26 08:27 AM

Please try converting to timestamp before

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

495 Views
0 Likes