By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT V.YourTime,
STUFF(NewTime, LEN(NewTime)-4,3,' ') AS NewTime
FROM (VALUES('09:00'),('17:45'))V(YourTime)
CROSS APPLY(VALUES(CONVERT(varchar(10),CONVERT(time(0),V.YourTime),109)))C(NewTime);
| YourTime | NewTime |
|---|---|
| 09:00 | 9:00 AM |
| 17:45 | 5:45 PM |