Convert Int to time

unknown

In jobtran_mst, the columns start_time and end_time are stored as INT.  When the data is displayed in Job Transactions Form, an SP is run to convert to time (formatted).

Example - start_time = 46860.  Displayed = 13:01.

Trying to understand how to do this manually when I extract the data raw and don't have the SP to do the work.

Regards,

Lance

unknown

Solved.  One of those cases where I tried everything, posted the question, then the answer presented itself.

The time is stored in seconds.  Use the value stored / seconds in a day.  Convert that to time.

Regards,

Lance