Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date and time related interpretation

Hi,

     I'm new to Qlikview.

   

       hour( '09:14:36' ) returns 9

      hour( '0.5555' ) returns 13 ( Because 0.5555 = 13:19:55 )

     Can anyone explain how QlikView interprets 0.5555 as '13:19:55' in case of Date and Time Functions?

Regards,

Sudharshan

1 Reply
MarcoWedel

0.5555 * 24hours = '13:19:55'