select to_char ( to_date ( '2300', 'HH24MI'), 'HH:MI') integer_time from dual;

Result:
INTEGER_TIME
--------
11:00

SELECT LPAD('937', 4, '0') FROM dual

SELECT LPAD('1937', 4, '0') FROM dual