Looking for solution: INT to Time HH:MM:SS converted in the Cube

Comments

2 comments

  • Avatar
    Nathan Giusti

    ADDSECONDS(CreateDate(1970, 1, 1), [seconds])

    1
    Comment actions Permalink
  • Avatar
    John Randolph

    Hi Nathan,

    This is an interesting solution. Now I just need to figure out how to trim the date and milliseconds in the same expression to leave me with hh:mm:ss. 

    I really appreciate your reply!

    John

    0
    Comment actions Permalink

Please sign in to leave a comment.