topic date and time related interpretation in QlikView https://community.qlik.com/t5/QlikView/date-and-time-related-interpretation/m-p/830712#M998392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I'm new to Qlikview.</P><P>&nbsp;&nbsp;&nbsp; </P><P><SPAN class="Code">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hour( '09:14:36' )</SPAN> returns 9 </P><P><SPAN class="Code">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hour( '0.5555' )</SPAN> returns 13 ( Because 0.5555 = 13:19:55 )</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Can anyone explain how QlikView interprets 0.5555 as '13:19:55' in case of Date and Time Functions?</P><P></P><P></P><P>Regards,</P><P>Sudharshan</P></BODY></HTML> Tue, 16 Jun 2015 10:16:19 GMT 2015-06-16T10:16:19Z date and time related interpretation https://community.qlik.com/t5/QlikView/date-and-time-related-interpretation/m-p/830712#M998392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I'm new to Qlikview.</P><P>&nbsp;&nbsp;&nbsp; </P><P><SPAN class="Code">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hour( '09:14:36' )</SPAN> returns 9 </P><P><SPAN class="Code">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hour( '0.5555' )</SPAN> returns 13 ( Because 0.5555 = 13:19:55 )</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Can anyone explain how QlikView interprets 0.5555 as '13:19:55' in case of Date and Time Functions?</P><P></P><P></P><P>Regards,</P><P>Sudharshan</P></BODY></HTML> Tue, 16 Jun 2015 10:16:19 GMT https://community.qlik.com/t5/QlikView/date-and-time-related-interpretation/m-p/830712#M998392 2015-06-16T10:16:19Z Re: date and time related interpretation https://community.qlik.com/t5/QlikView/date-and-time-related-interpretation/m-p/830713#M998393 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">0.5555 * 24hours = '13:19:55' </SPAN></P></BODY></HTML> Tue, 16 Jun 2015 15:15:50 GMT https://community.qlik.com/t5/QlikView/date-and-time-related-interpretation/m-p/830713#M998393 MarcoWedel 2015-06-16T15:15:50Z