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