Need help to convert time to EST

Wed, 17 Jun 2015 13:52:18 GMT

I have a time stamp column in my table but the time zone is not known.

but there is a timezone offset column in seconds which suggest how much the given time stamp is behind in Seconds from GMT

So first i need to convert the time stamp in GMT by adding the timezone offset time and then need to convert that GMT time stamp in EST.

Please help . Sample file is attached

Re: Need help to convert time to EST

Kushal_Chawda — Wed, 17 Jun 2015 14:02:06 GMT

Use ConvertToLocalTime() function. See the help section in qlikview for more information of this fucntion

Re: Need help to convert time to EST

MarcoWedel — Sat, 20 Jun 2015 21:47:46 GMT

Hi,

one solution could be:

table1:

LOAD Timestamp,

TimeZoneOffset,

Timestamp(Timestamp-TimeZoneOffset/86400) as TimestampGMT,

ConvertToLocalTime(Timestamp-TimeZoneOffset/86400,'GMT-05:00') as TimestampEST

INLINE [

Timestamp, TimeZoneOffset

06/20/2015 01:23:45, 25200

06/20/2015 12:34:56, 25200

06/20/2015 23:45:01, 25200

06/20/2015 11:11:11, 25200

06/20/2015 00:00:00, 25200

06/20/2015 01:00:00, 25200

06/20/2015 02:00:00, 25200

06/20/2015 03:00:00, 25200

06/20/2015 04:00:00, 25200

06/20/2015 05:00:00, 25200

06/20/2015 06:00:00, 25200

06/20/2015 07:00:00, 25200

06/20/2015 08:00:00, 25200

06/20/2015 09:00:00, 25200

06/20/2015 10:00:00, 25200

06/20/2015 11:00:00, 25200

06/20/2015 12:00:00, 25200

06/20/2015 13:00:00, 25200

06/20/2015 14:00:00, 25200

06/20/2015 15:00:00, 25200

06/20/2015 16:00:00, 25200

06/20/2015 17:00:00, 25200

06/20/2015 18:00:00, 25200

06/20/2015 19:00:00, 25200

06/20/2015 20:00:00, 25200

06/20/2015 21:00:00, 25200

06/20/2015 22:00:00, 25200

06/20/2015 23:00:00, 25200

];

hope this helps

regards

Marco

topic Need help to convert time to EST in QlikView

Need help to convert time to EST

Re: Need help to convert time to EST

Re: Need help to convert time to EST