3 Replies Latest reply: Sep 6, 2017 3:46 AM by Sascha Seifert RSS

    Question concerning Date and Long Timestamps in SQL Database

    Sascha Seifert

      Hi dear Qlik Community,

       

      before I start with my question, I wanted to say that the Qlik Community is maybe the best online help forum on the internet.

       

       

      I need to load data from an SQL Server and put it into a QVD. I have serious problems with a Timestamp field.

       

      These are the options concerning the field:1

      This is how the data looks on the SQL Database:

      This is how it looks in my QVD File:

       

      Here is my Statement:

       

      OEE_RES_STATE_SAMP:
      LOAD text(RSS_TIMESTAMP_START) as NewDate;

       

      SQL SELECT "RSS_TIMESTAMP_START"
      FROM xxx.dbo."xxx_xxx_xxx_xxx";

       

      All I want to do is to make a date out of this timestamp -> yyyy-mm-dd hh:mm:ss.fff

       

      Would anybody please assist me ?

       

      Thank you in advance