如何在jooq中将double转换为date

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

public class Main {
    public static void main(String[] args) {
        // 创建数据库连接配置
        String url = "jdbc:mysql://localhost:3306/db";
        String username = "username";
        String password = "password";
        Configuration configuration = new DefaultConfiguration()
                .set(SQLDialect.MYSQL)
                .set(url, username, password);

        // 创建DSLContext对象
        DSLContext create = DSL.using(configuration);

        // 执行查询
        Result<Record1<Date>> result = create.select(field(name("your_double_field")).cast(SQLDataType.DATE))
                .from(table(name("your_table")))
                .fetch();

        // 处理查询结果
        for (Record1<Date> record : result) {
            Date date = record.getValue(0);
            System.out.println(date);
        }
    }
}