Thanks for your message. jOOQ doesn't have native support for this function. But you can always add support for vendor specific functionality using a plain SQL template: https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating/
I hope this helps, Lukas On Wed, Jan 17, 2024 at 4:30 PM Konstantin Kuzmin <[email protected]> wrote: > Hello! How to convert this sql to jooq? Thx > select extract(year from AGE(now(), to_timestamp(cti_birthdate_id::text, > 'YYYYMMDD'))) from citizen_identity; > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/a4f8ba9d-4983-4c02-a000-241de8f70296n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/a4f8ba9d-4983-4c02-a000-241de8f70296n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7bpWffBDZzhTvsLeLS0hBMZiaoEHvQcfoS0mJqa1hvdQ%40mail.gmail.com.
