SQL Server: TSQL How to get the time from datetime

In TSQL on SQL Server 2005, how do you get the time part from a datetime field?

SELECT CONVERT (VARCHAR (8), YourDatetimeField, 108)

FROM YourTable

 

Comments are closed