7 Replies Latest reply: Jul 4, 2012 4:19 PM by Juan Lopez RSS

    Converting a millisecond value to a Time value

    Adam Abwat-Johnson


      I'm hoping this has an easy answer I'm not seeing but here goes.

      I'm trying to convert a millisecond value field from a table to show as a time value, for example 7,200,000 milliseconds to show as 02:00:00 and 8,100,000 to show as 02:15:00.

      I'm looking through all of the functions and can't seem to find an easy way to do this with hundreds of records in this table, all having this issue. I know I need to put something in the load statement but I don't know what.

      Can anyone tell me if there is an easy way to do this?