Sorry,

Your solution is PERFECT

datediff(hh,utcdate,getdate()) is exactly what I need!

So this looks like a 3 line command, I really want something like this

select convert(utcdatecolumn),column2, column3

from table

without creating a function, there is no way to do it?