topic How to convert from local time? in QlikView

How to convert from local time?

rbecher — Mon, 19 Mar 2012 22:01:55 GMT

Hi all,

as you might know there is a function ConvertToLocalTime to convert a UTC/GMT timestamp to local time with the adjustment for daylight savings time.

But, how about the other direction? Why there is no function for this?

In my case I have a local time which I need to convert to UTC without daylight savings time! I know I could preload calendar table with daylight saving offset (how to generate?) or something else. But this would be very disappointing...

ConvertFromLocalTime() would be needed or DaylightSaving([timestamp][,place]).

Any suggestion?

- Ralf

How to convert from local time?

Mon, 19 Mar 2012 22:28:39 GMT

Is this relevant to your question?

http://community.qlik.com/message/159051#159051

How to convert from local time?

rbecher — Mon, 19 Mar 2012 22:38:16 GMT

No, doesn't help.

Re: How to convert from local time?

Mon, 19 Mar 2012 22:41:39 GMT

Does this help?

http://community.qlik.com/message/122963

Edit: Probably not. I tried, sorry friend.

How to convert from local time?

rbecher — Mon, 19 Mar 2012 22:52:53 GMT

There is a first idea:

I could act like my local time would be in GMT and do this test calculation for daylight saving:

=if( ConvertToLocalTime(<timestamp>, 'Berlin') - ConvertToLocalTime(<timestamp>, 'Berlin', true()) > 0, 'daylight saving', 'not')

But there should be a better way.

- Ralf

How to convert from local time?

Fri, 20 Apr 2012 11:24:20 GMT

Hi, I have problem with Convert local time function while i using that =Convertlocaltime(Today(),'kolkata') than its returns 4/20/2012 5:37 AM whenerver the current time is 4/20/2012 4:47 PM. Can guide me what is the exact problem. plzzz.

How to convert from local time?

Fri, 20 Apr 2012 16:10:20 GMT

@rakeshcgbsil

It's probably best to create your own thread instead of bringing up old topics.

Check out this thread, http://community.qlik.com/thread/37530.

How to convert from local time?

suniljain — Tue, 24 Apr 2012 06:58:06 GMT

=ConvertToLocalTime(UTC(),'Kolkata')

Re: How to convert from local time?

kevinpintokpa — Tue, 15 Nov 2016 20:45:22 GMT

Thanks, I had the same problem, how to convert from local time to UTC with and without daylight savings time and this worked for me 🙂

Re: How to convert from local time?

janbouwmans — Fri, 14 Sep 2018 13:21:41 GMT

Hi Ralf,

I used the following solution based on your idea to convert to GMT in one step:

TimestampGMT=timestamp(ConvertToLocalTime(TimestampLocal,'GMT') - ConvertToLocalTime(TimestampLocal,'Rome')+TimestampLocal)

This automatically corrects for DaylightsavingTime