Your safest bet is to use DSL.dateAdd() for this:
http://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#dateAdd-org.jooq.Field-java.lang.Number-org.jooq.DatePart-
E.g.
MY_TABLE.DATE.ge(DSL.dateAdd(Date.valueOf("2014-08-14"), -6,
DatePart.MONTH))
Hope this helps,
Lukas
2014-09-10 12:08 GMT+02:00 <[email protected]>:
> Hi,
>
>
> I am having a problem with implementing MySQL date interval function in
> JOOQ. What I am trying to do is,
>
> date >= '2014-08-14' - INTERVAL 6 MONTH
>
> Please help me to implements this this using JOOQ.
>
> Thanks,
> Lakmal.
>
> --
> 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.
