topic Dealing time changes in QlikView

Dealing time changes

Joaquin_Lazaro — Tue, 17 Nov 2015 14:30:39 GMT

Hi people:

I have a some table records based on a timestamp, some weeks ago there was the winter time changes and the information between 02:00 am and 03:00 have two different records. I don't want to sum both records.

Is there any best practices, white paper or anything else which explain how to deal with time changes ?

I'm not talking/writing about setting up my server time !!!

Thank you

Joaquín

Re: Dealing time changes

pljsoftware — Tue, 17 Nov 2015 14:40:47 GMT

Hi Joaquin,

you have to use UCT if you want always that your data have invariant time.

Best Regards

Luca Jonathan Panetta

Re: Dealing time changes

Joaquin_Lazaro — Tue, 17 Nov 2015 16:03:59 GMT

Hi Luca;

Thanks for your support.

Joaquín