2 Replies Latest reply: Aug 9, 2017 3:13 PM by Martha Parsons RSS

    Convert number .0000150462962962963 to Time - coming from SAS

    Martha Parsons

      Hello,

       

      How do I convert date with numbers like .0000150462962962963 to Time - coming from SAS? In the data set from SAS I set it to time, but it still pulls into Qlikview as a number. I have tried several formats and none are working.

       

        timestamp(Timestamp(Hour, 'HH:MM:SS TT'),'HH:MM ') as time,

           Interval(Time(Hour, '0123456789.')/1440, 'h:mm:ss') as NewTime,

            Interval(Date(Hour, '0123456789.')/1440, 'h:mm:ss') as NewTime2,

       

      Another example of an hour in decimal is 1.15740740740741E-05

       

      When I run it in SAS Enterprise Guide it is in hh:mm format.

       

      Thank you,

      Martha