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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.