title: Convert Number (decimal format) to Time
body: <p>I have a column CPTIME with the data type decimal(6,0). Current value looks like 165750. I need it to be in TIME format 16:57:50. Is there a way to do that? I have seen somewhat similar questions asked, but that was with decimal hours/minutes (ie. 16.57 as 16:57), which does not apply here.</p>