Hi Denis, In our eternal promise to integrate JSR 310 with jOOQ, we're constantly
1. Struggling with finding a standard integration among databases 2. Find a good solution to overload existing API that accepts JDBC temporal types with JSR 310 temporal types The latter is a real impediment here, as due to generic type erasure (and lack of union type support), there is no way of overloading this year(Field<? extends java.util.Date>) method. We could, of course, remove the type constraint and accept year(Field<?>), but that hasn't been decided yet. In the meantime, you'll have to resort to plain SQL to generate a native version of the EXTRACT() function for your database. Best Regards, Lukas 2016-04-22 17:16 GMT+02:00 Denis Miorandi <[email protected]>: > Hello, > probably is trivial but I can't figurate how to do it. > > I need to write this expression > > create.select ( > DSL.year(MYTABLE.MYFIELD) > ) > .from ...... > > > where MYTABLE.MYFIELD is a java.time.LocalDate. > How can I achieve this? > > Tks > Denis > > -- > 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.
