select hour(timefield) as 'f1' from table1 group by f1

[Joseph Morgan]

On Oct 17, 2007, at 8:33 AM, Ivan Smahin wrote:

> Could you report it to Mantis please?
>
> Workaround:
> Add   field-method   to   the   table   table1.   Method   text  is  -
> hour(timeField).
>
> Now your query will look like this:
> select m1 from table1 group by m1


Ok but I find that this works so I'll use this:

select f1 from (select hour(timefield) as 'f1' from table1) group by f1


Thanks,
Joseph