topic Re: Logic in QlikView

Logic

panipat1990 — Thu, 17 Sep 2015 18:59:12 GMT

Hi Team,

I have Time stamp in UTC format and my requirement is to convert the same UTC time stamp into Pacific Time format.

How can i do this on qlikview platform?.

Thanks

maxgro — Thu, 17 Sep 2015 19:01:59 GMT

copied from QlikView 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.

Examples:

ConvertToLocalTime(’2007-11-10 23:59:00’,’Paris’) returns ’2007-11-11 00:59:00’ and the corresponding internal timestamp representation.

ConvertToLocalTime(UTC(), ’GMT-05:00’) returns the time for the North American east coast, e.g. New York.

MarcoWedel — Thu, 17 Sep 2015 23:37:29 GMT

Hi,

you could use

ConvertToLocalTime(YourUTCTimeField, 'UTC-08:00')

hope this helps

regards

Marco

panipat1990 — Fri, 18 Sep 2015 11:23:42 GMT

Thanks. Marco

it is really helpful.