I know that I can get the time segments from the datediff() function, but is there a way to return HH:MM from sql server?

Thanks
Kirk