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]>:
> 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].
> 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.
