(no subject)

[Ivan Smahin]

Hello Joseph,

Wednesday, October 17, 2007, 10:41:40 AM, you wrote:

> Hello,

> Is the following query possible:

> "select hour(timeField) from table1 group by hour(timefield)"

> I get error: "unexpected token: ("

> I'm sure the error is coming from the group by section but not sure  
> if there is a
> work around. This works in mysql no problem and was hoping to use in  
> valentina.

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

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com