I'd like to aggregate reporting data that is currently stored hourly in a table, such that it is also aggregated by day (I have a column that specifies the interval, HOUR, DAY, or WEEK).
Postgres has a useful function called DATE_TRUNC for this, however I am using Jooq with MySql. How can I do this with Jooq? Many thanks, Ian.
