8 Replies Latest reply: Nov 30, 2016 9:06 AM by Jérémy Bonde RSS

    No time value from a DateTime field

    Jérémy Bonde

      Hello,

      I'm working on Qlik Sense 3.1 RC2 (and my bug also occured on 3.1 RC1). I worked on some other versions and didn't have this bug :


      When I load my data from a SQLite file (using ODBC) or from a CSV file, I can not extract time from my datetime fields (format : MM/dd/yyyy hh:mm:ss).

       

      I tried these in the loader :
      - right(field, 8) as fieldname => only date number value is retrieve (42000...)

      - date(field, 'hh:mm:ss') => 00:00:00

       

      I never had this kind of bug. I tried to reinstall (that's why I tested it on RC1 and RC2 of 3.1 version) and it didn't change anything.

       

      Is it a bug or does something has changed ?