Thanks! Am Mittwoch, 29. März 2017 10:51:44 UTC+2 schrieb Lukas Eder: > > Hi Jens, > > Thanks for your message. This is being worked on for jOOQ 3.10: > https://github.com/jOOQ/jOOQ/issues/5645 > > Currently, you'll have to roll your own, e.g. this might work (not tested): > > class MyDSL { > public static Field<LocalDate> localDateSub(Field<LocalDate> field, > int number, DatePart part) { > return DSL.dateSub(field.coerce(LocalDate.class), number, > part).coerce(LocalDate.class); > } > } > > > Or, as always: A plain SQL based solution if the above doesn't work for > this particular case. > > Hope this helps, > Lukas > > 2017-03-29 10:16 GMT+02:00 jklingsporn <[email protected] <javascript:> > >: > >> Hi, >> I just wanted to use the DSL.dateSub(Field<sql.Date>,int,DatePart) method >> for a MySQL datetime field that I am using. In code-generation I've set the >> <javaTimeTypes> flag so the field is not of type sql.Date but LocalDateTime >> which does not fit of course. Is there a workaround for this? >> >> Kind regards, >> Jens >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- 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/d/optout.
