14 Replies Latest reply: Jan 22, 2013 10:50 AM by dbuijsman RSS

    Remove last 10 numbers from values

      Hello,

       

      A simple question from a Qlikview personal edition user. I'm using an Oracle database with a numeric column which looks like the follow:

       

      TVRZ
      201210050700120000
      201210050700130000
      201210090700150000
      201210090700140000
      201210090700160000
      201210100700190000
      201210100700170000
      201210100700180000
      201210110700140000

       

      These numbers are supposed to be dates, the first 8 digits represents a date. I dont know why the values are 18 digits long, it is still to long if it is including the hh:mm:ss.

      I still want to load it as a date so i can do some calulations with it. Does somebody know how i can load the column without the last 10 digits and load it as a normal date value?