topic Load the Milli Seconds (full timestamp value) from DB in QlikView https://community.qlik.com/t5/QlikView/Load-the-Milli-Seconds-full-timestamp-value-from-DB/m-p/421510#M560191 <HTML><HEAD></HEAD><BODY><P>Hi Folks, We have a event table and all the events was stored into DB table with Time stamp (included Milli Seconds).</P><P></P><P>I load the data and I didn't see any Milli seconds on Qlikview.</P><P></P><P>Please help me how can I load the milli seconds from DB and show on Qlikview charts.</P></BODY></HTML> Thu, 02 May 2013 18:19:02 GMT 2013-05-02T18:19:02Z Load the Milli Seconds (full timestamp value) from DB https://community.qlik.com/t5/QlikView/Load-the-Milli-Seconds-full-timestamp-value-from-DB/m-p/421510#M560191 <HTML><HEAD></HEAD><BODY><P>Hi Folks, We have a event table and all the events was stored into DB table with Time stamp (included Milli Seconds).</P><P></P><P>I load the data and I didn't see any Milli seconds on Qlikview.</P><P></P><P>Please help me how can I load the milli seconds from DB and show on Qlikview charts.</P></BODY></HTML> Thu, 02 May 2013 18:19:02 GMT https://community.qlik.com/t5/QlikView/Load-the-Milli-Seconds-full-timestamp-value-from-DB/m-p/421510#M560191 2013-05-02T18:19:02Z Re: Load the Milli Seconds (full timestamp value) from DB https://community.qlik.com/t5/QlikView/Load-the-Milli-Seconds-full-timestamp-value-from-DB/m-p/421511#M560192 <HTML><HEAD></HEAD><BODY><P>The milliseconds are probably loaded, just not displayed. If you specify a timestamp format like DD/MM/YYYY hh:mm:ss.fff you should see the milliseconds as the fff part. Try adding the timestamp field to a listbox or table box and on the Number tab of the properties window of the object check the option Override Document Settings, choose timestamp and adjust the Format Pattern to your liking.</P></BODY></HTML> Thu, 02 May 2013 18:25:00 GMT https://community.qlik.com/t5/QlikView/Load-the-Milli-Seconds-full-timestamp-value-from-DB/m-p/421511#M560192 Gysbert_Wassenaar 2013-05-02T18:25:00Z