How to convert Time from int to Real-time

[ahains]

I have an ugly, but hopefully correct way of converting those times:

Thank you for that, it makes my method look not hacky at all in comparison

[TaulPall]

Wow, I've written some pretty ugly T/SQL but nosepicker's surpasses all. -- although, it does appear to work. I wouldn't put anything like it into production.

[TaulPall]

This example takes a julian date, expressed as a decimal, and converts it to human readable hour with meridian:

select substring(cast(convert(datetime, 39750.33333335, 101) as varchar),13,20)