Hello, Yes, I was playing around with that feature some time ago: https://github.com/jOOQ/jOOQ/issues/470
Unfortunately, correctly simulating date time arithmetic through a standard API for every database takes a lot of time, which is why I have not yet implemented this. If you want to use any function that is missing from jOOQ, just use plain SQL as documented here: http://www.jooq.org/doc/2.6/manual/sql-building/plain-sql/ An example: Factory.field("trunc({0}, {1})", SQLDataType.TIMESTAMP, date, datepart); 2012/11/23 Ben Hood <[email protected]>: > Hi, > > I've noticed that TRUNC(date, datepart) are non-public static methods on the > Factory that lead to a not implemented exception (at least in the 2.5.1 > API). > > What would be the best way to invoke this (on Oracle and HSQL)? > > Cheers, > > Ben
