Get the time of a datetime using T-SQL?

Question

How to get the time for a given datetime value?

I have a datetime in database like this:

2010-09-06 17:07:28.170

and want only the time portion:

17:07:28.170

Is there a function for that or something?

user_662403 · Answer

Try this

SELECT CAST(DataField AS time(7)) AS 'time'

user_9006868 · Answer

You can try the following code to get time as HH:MM format:

 SELECT CONVERT(VARCHAR(5),getdate(),108)