JOOQ日期格式化

@Override
public Map<String, List<TmstaInEntity>> queryForEcharts(TmstaInQuery query) {
    return create.select(tmsta01In.STATUS_BEGIN, tmsta01In.STATUS_END
            ,dateFormat(tmsta01In.STATUS_BEGIN, "%Y-%m-%d").as("statusDate"))
            .from(tmsta01In).where(tmsta01In.DEVICE_NO.eq(query.getDeviceNo()))
            .fetchGroups(dateFormat(tmsta01In.STATUS_BEGIN,"%Y-%m-%d").as("statusDate"), TmstaInEntity.class);
}

public static Field<String> dateFormat(Field<Timestamp> field, String format) {
    return DSL.field("date_format({0}, {1})", SQLDataType.VARCHAR,
            field, DSL.inline(format));

}

原文地址:http://w3cgeek.com/sql-date_format-in-alternative-in-jooq.html