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)