2 Replies Latest reply on Jan 31, 2019 1:59 AM by mursid rahman

    Converting Integer to Time

    mursid rahman



      I need help in converting integer to time format. Currently my time dimension is in integer format. 24hour integer format. I need it to be converted into time format. Below is the snapshot for your reference.


      Transaction Time.PNG


      For example, the last row is 221903. I want to convert it to 22:19:03 and another example is the first row which is 14552 to 1:45:52.


      Thank you in advance.