Hi Lisa, Thanks for your message. Please use DSL.year() for this: https://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#year-org.jooq.Field-
Your first place to look for any SQL function is also the DSL class. If it is not available, you can always support it manually using the plain SQL templating API: https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating I hope this helps, Lukas On Fri, Dec 7, 2018 at 12:26 PM <[email protected]> wrote: > .from(PRESENCAS) > .innerJoin(XXXX).on(XXXXXX.AAAA.eq(XXXX.AAAAa)) > .innerJoin(BBBB ).on(BBBB.DDDDD.eq(CCCCC.DDDD)) > .where((TEST.LTESTENUM.ge(number))) > . where((TEST.LTESTENUM.greaterOrEqual(number)).and( > *//YEAR(TABLE.TIMESTAMP_FIELD)>2017');* > .fetch(); > > > Hi everyone, please I need to add this condition > > *//YEAR(TABLE.TIMESTAMP_FIELD)>2017');* > > in my selection I am not getting it, I appreciate the help! > Thanks > > -- > 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.
