Question: how to convert hhmmss to time in sql?
Answer: Basically, convert the integer HHMMSS time field into seconds, and use DATEADD to combine it with the date field IBUPMJ.