#3009 is now implemented for jOOQ 3.3.0. It was a rather low-hanging fruit. You will be able to add minutes to any DATE_FIELD (or TIMESTAMP_FIELD) as such:
DSL.dateAdd(DATE_FIELD, 5, DatePart.MINUTE); Best Regards, Lukas 2014-02-05 Lukas Eder <[email protected]>: > 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.
