Group By Hour Query Error

[sjgbrown]

I've got an integer column that contains Seconds Since Midnight and I'd like to group it by hour. This is the query:

SELECT
Floor(XALOADS.ProTime/3600),
COUNT(XALOADS.LoadID)
FROM PUB.XALOADS
WHERE XALOADS.ProDate = sysdate
AND XALOADS.LoadStatus ='P'
GROUP BY Floor(XALOADS.ProTime/3600)

I'm getting the following error when it runs:

=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)

Any ideas what's wrong?

TIA,

Sean Brown