Qlik Sence stores each date, time and time stamp found in data as a datetime Serial number.
The date time for 01/01/2014 06:00:00 is represented as 41640.25 where:
- The integer part, 41640, represents the date and is the number of days elapsed since Dec.30, 1899.
- The decimal part represents the time stored as a value between 0 and 1. This nummber is the faction of elapsed time from a full day. Therefor, 06:00:00 is six hours elapsed from a full day, or 0,25. The value 0.0 corresponds to 00:00:00, 0.99999 coresponds to 23:59:59.
Text displayed: 4/26/2012
When you load data into Qlik Sence, fields containing numbers with a defined data type in a database are handled according to their respective formats.
You can use to define input and Output Formats of Dates:
- Data(), Time() --> Formating functions define the Format for how to present the data in Qlik Sence
- Data#(), Time#() --> Number Interpretation function that define the data Format of the date being loaded into Qlik Sence.