how to get time part from datetime in sql code example Example: get time component of datetime sql SELECT convert(varchar(8), getdate(), 108)