Sorry if this has been asked befor, but I couldn't find anything that hepled me.

I have a datetime field and want to extract only the time. I know it works with CONVERT and style-type 108. But I get something like this: 08:00:00 and I need something like this: 08:00.

Can this somehow be done?

Michael