Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

DateTime data type is a floating point
It is important to understand that, underneath, the DateTime data type is represented by a floating point number. For example, 12 noon on May 22nd 2012 is stored as 41,051.5. The whole number 41,051 represents the date; it is the number of days that have passed since December 31st, 1899. The fractional part 0.5 represents the time. As a day (24 hours) is 1, an hour is 1/24 and 12 hours is 12/24, which is equal to 1/2 or 0.5. Knowing this, we can use many of the numeric functions that we saw earlier to perform date and time calculations. For example, we can use the Floor()function to remove the time information from a date.
If you want to change selection, open document below and click on "Move attachment"


owner: ngras - (no access) - QlikView 11 for Developers [eBook].pdf, p273


statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on



Do you want to join discussion? Click here to log in or create user.