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