将日期时间字段与JOOQ一起使用Group by date

import static org.jooq.impl.DSL.*;
import org.jooq.*;

// 创建数据库连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
DSLContext context = DSL.using(connection, SQLDialect.MYSQL);

// 定义表和字段
Table<Record> myTable = table("my_table");
Field<Timestamp> dateTimeField = field("date_time", Timestamp.class);

// 执行查询
Result<Record2<Date, Integer>> result = context.select(
    date(dateTimeField).as("date"),
    count()
)
.from(myTable)
.groupBy(date(dateTimeField))
.fetch();

// 遍历结果
for (Record2<Date, Integer> record : result) {
    Date date = record.get("date", Date.class);
    int count = record.get("count", Integer.class);
    
    // 进行相应的处理
    System.out.println("Date: " + date + ", Count: " + count);
}