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