topic Re: Time Format in QlikView

Time Format

agni_gold — Mon, 02 Dec 2013 12:18:51 GMT

May 22nd 2012 is stored as 41,051.5 , what this number signifies. Please tell .

Re: Time Format

rustyfishbones — Mon, 02 Dec 2013 12:25:16 GMT

it represents the date and time as a number

22/05/2012 12:00

Paste it into excel and format it and it will show you it's a Date and time dd/mm/yyyy hh:mm

Re: Time Format

CELAMBARASAN — Mon, 02 Dec 2013 12:34:36 GMT

Qlikview Internally maintains Date as number.

41,051.5 in this

1 day is represented as 1

1 hour is represented as 1/24

1 minute is represented as 1 / (24 * 60) and so on

Starting from 12/31/1899 it counts 41051 When it is May 22nd.

Hope it helps

Re: Time Format

agni_gold — Mon, 02 Dec 2013 12:37:07 GMT

Thats my question why it started to count from 12/31/1899

Re: Time Format

sundarakumar — Mon, 02 Dec 2013 12:39:47 GMT

It is default...

Just to maintain a standard, they have set it like that way..

u cannot manually change it..

Re: Time Format

tresB — Mon, 02 Dec 2013 12:49:13 GMT

There are several date systems followed by different tools. The most common one (used by excel as well) is the one called:

The 1900 Date System

In the 1900 date system, the first day that is supported is January 1, 1900. When you enter a date, the date is converted into a serial number that represents the number of elapsed days since January 1, 1900. For example, if you enter July 5, 1998, Microsoft Excel converts the date to the serial number 35981.

Qlikview uses 1900 Date System. Hence the number you see.

Hope clarifies.

Re: Time Format

Anonymous — Mon, 02 Dec 2013 15:59:14 GMT

To keep it in sync with Excel. So, the integer representation of dates in QV and Excel are the same.