SQL Server conversion for TO_DATE

[ScottPletcher]

select datediff(minute, cast('10:20' as time), cast('10:40' as time)) / (60.0 * 24) /* 60 * 24=#ofmins_in_a_day */