get time component of timesyamp sql code example

Example: get time component of datetime sql

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