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