Need help to convert time to EST

[#1]

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

[Kushal_Chawda]

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

[MarcoWedel]

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