topic Re: How to split this in to Date & Time Fields? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835939#M1007824 <HTML><HEAD></HEAD><BODY><P>Splitting a timestamp into separate date and time values will reduce the memory required to hold the data compared to a timestamp field. This is often a good idea!</P><P></P><P>You can use <STRONG>floor()</STRONG> to extract the date part of a timestamp, and <STRONG>frac()</STRONG> to get the time portion.</P><P></P><P>Have a look at these documents for more details</P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Fri, 22 May 2015 14:26:33 GMT Colin-Albert 2015-05-22T14:26:33Z How to split this in to Date & Time Fields? https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835937#M1007822 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87299_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 22 May 2015 14:18:33 GMT https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835937#M1007822 MuraliPrasath 2015-05-22T14:18:33Z Re: How to split this in to Date & Time Fields? https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835938#M1007823 <HTML><HEAD></HEAD><BODY><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(floor(loggedintime)) as DateField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Time(frac(loggedintime)) as TimeField,</P><P>...</P></BODY></HTML> Fri, 22 May 2015 14:23:16 GMT https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835938#M1007823 swuehl 2015-05-22T14:23:16Z Re: How to split this in to Date & Time Fields? https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835939#M1007824 <HTML><HEAD></HEAD><BODY><P>Splitting a timestamp into separate date and time values will reduce the memory required to hold the data compared to a timestamp field. This is often a good idea!</P><P></P><P>You can use <STRONG>floor()</STRONG> to extract the date part of a timestamp, and <STRONG>frac()</STRONG> to get the time portion.</P><P></P><P>Have a look at these documents for more details</P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Fri, 22 May 2015 14:26:33 GMT https://community.qlik.com/t5/QlikView/How-to-split-this-in-to-Date-Time-Fields/m-p/835939#M1007824 Colin-Albert 2015-05-22T14:26:33Z