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

[Joseph Morgan]

On Oct 17, 2007, at 2:50 AM, Ivan Smahin wrote:

> Try this:
> select hour(timeField) as 'f1' from table1 group by f1

I get this error:
08:22:47: Error: Kernel error: 0x51500. Identifier "f1" is not found.

It should work, but it is not.
Any suggestions

Thanks,
Joseph