Logic

[panipat1990]

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]

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]

Hi,

you could use

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

hope this helps

regards

Marco

[panipat1990 · Accepted solution]

Thanks. Marco

it is really helpful.