get time component of datetime sql
snippet in sql

get time component of datetime sql

user4704

SELECT convert(varchar(8), getdate(), 108)