topic Time Zone Conversation in QlikView

Time Zone Conversation

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can any one please help me.Please find the attachment.

Here the ‘Time’ that is displayed is of UK country timings.Need to convert them into USA Eastern Time Zone timings.

Re: Time Zone Conversation

Chanty4u — Wed, 23 Mar 2016 09:41:01 GMT

chk dis

Convert time from EST to GMT & EST to Philippine Time Zone

Re: Time Zone Conversation

avinashelite — Wed, 23 Mar 2016 09:48:34 GMT

first convert time from UK to UTC ..then from UTC you can convert to required timezone

Try like this

converttolocaltime(converttolocaltime(fieldname,'UTC'),'Pacific Time (USA & Canada)')

Re: Time Zone Conversation

Kushal_Chawda — Wed, 23 Mar 2016 11:35:30 GMT

Perhaps you need to use ConvertToLocalTime function. see the below link to help understand the function.

I am sure you will be able to get the answer after understanding this fucntion

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/converttolocaltime.ht…

Re: Time Zone Conversation

avinashelite — Wed, 23 Mar 2016 11:39:48 GMT

ConvertToLocalTime(timestamp [, place [, ignore_dst=false]])

takes three parameters

1.Your time stamp field

2. Format that you need to convert

3. Optional, daylight saving parameter if its true() daylight will be automatically adjusted and if its false() than it will not adjust the daylight saving .

In your case you need to convert the UK time to USA so first we need to convert it to UTC ot GMT than convert it to USA with the daylightsaving parameter as true

Try this

converttolocaltime(converttolocaltime(Date,'UTC'),'Pacific Time (USA & Canada)',true())

Re: Time Zone Conversation

bhavvibudagam — Wed, 23 Mar 2016 13:31:05 GMT

Thank you Avinash

Re: Time Zone Conversation

bhavvibudagam — Wed, 23 Mar 2016 13:31:44 GMT

Thank you its working.

Re: Time Zone Conversation

avinashelite — Thu, 24 Mar 2016 05:36:58 GMT

If you have got the answer please mark the correct and helpful answers so that it will helpful for others who are having similar questions

Re: Time Zone Conversation

jhona1737 — Wed, 05 Sep 2018 16:21:45 GMT

Hi Avinash,

I got a question, my Qliksense server is on UK time but my data warehouse is on EST time, this is how I am getting the data

FROM "IS_Local_NAV".dbo.Package where ProductionDate Between '2018-09-01' and GETDATE()-1;

but the problem is that at 12AM UK stop adding the data from 8PM to 12AM USA as show below

Thank you