You can use CONVER() function.
SELECT CONVERT(char(5), getdate(),108)
>HI,
>
>I´m trying to do a query with a field datatime type, i would like to format the result to the follow mask '10:00'.
>
>I tried to use DatePart function, but i only can retrieve the Hour.
>
>i´m using the follow SQL Expression:
>SELECT clientesPortas.descricao, DATENAME( hour , fluxo.dataHora)
>From clientesPortas.
>
>how can i do it?
>
>
>thanks
--sb--