in Sqlserver2008:

Select cast(your Column as time) [time]
from yourtable

Check this link:
sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/[^]

SELECT (getdate()),substring(CONVERT(VARCHAR, GETDATE(), 108),0,6) AS Time