topic Re: Convert to GMT+4 in QlikView

Convert to GMT+4

Mon, 31 Aug 2015 09:49:17 GMT

Hi All,

I am currently using the below to convert my time:

Time(Frac(CallUniversalTime), 'hh:mm:ss') as Time

However, I need to convert this time to GMT+4.

Any Idea how i can incorporate it in my load script.

Many Thanks,

Hasvine

maxgro — Mon, 31 Aug 2015 09:54:23 GMT

try with ConvertToLocalTime (this is from Qlik help)

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

Converts a UTC or GMT timestamp to local time as a dual value. The place can be any of a number of cities, places and time zones around the world.

ConvertToLocalTime(UTC(), ’GMT-05:00’) returns the time for the North American east coast

sunny_talwar — Mon, 31 Aug 2015 09:59:04 GMT

Using maxgro‌ provided function, try this:

=Time(Frac(ConvertToLocalTime(CallUniversalTime, 'GMT+04:00')), 'hh:mm:ss')