jooq-trunc-date.md

jooq DateでGroupByのコード

Result<Record3<Integer, Integer, BigDecimal>> fetch1
                    = DSL.using(conn)
                            .select(DSL.year(TABLE.DATE),
                                    DSL.month(TABLE.DATE),
                                    DSL.sum(TABLE.MYBIGINT))
                            .from(TABLE)
                            .groupBy(DSL.year(TABLE.DATE), DSL.month(TABLE.DATE))
                            .orderBy(DSL.year(TABLE.DATE), DSL.month(TABLE.DATE))
                            .fetch();

https://groups.google.com/forum/#!topic/jooq-user/8K2iiyU8orY