Hi Venkat, In principle, the dateAdd() function should also work for minutes, as it takes a SQL standard interval data type as an argument. For example, you can write:
DSL.dateAdd(DATE_FIELD, DSL.val(new org.jooq.types.DayToSecond(0, 0, 5))); The above roughly translates to dateadd(ss, 300, cast([DATE_FIELD] as datetime)) The above works when adding a Java value (bind value) to a field. I am aware, though, that there is room for many other datetime arithmetic functions. It would probably make sense to support (and emulate) something like: DSL.dateAdd(Field<? extends Date> date, Field<? extends Number> number, DatePart datePart); I have registered a feature request for this: https://github.com/jOOQ/jOOQ/issues/3009 Best Regards, Lukas -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
