8 Replies Latest reply: Oct 13, 2017 10:35 AM by Mark Graham RSS

    Convert number to Timestamp

    Mark Graham

      Hi all,

       

      I want to convert a field from number to Timestamp.

      Eg:

       

      201710112044  -    10/11/2017 08:44:00 PM (or) 10/11/2017 20:44:00


      I'm fetching it from AS400 DB.

      How do i do that in DB/QlikView?


      Any help is highly appreciated!