So, I am attempting to use MySQL-specific functions to do some date arithmetic. I have run into an issue, however, in that TIMESTAMPDIFF expects a "TIMSTAMP UNIT" as the first parameter to the function - this is essentially a "keyword" and is NOT a String.
So, I attempt to create my SQL as follows via OpenJPA: But that results in the following invalid SQL statement: What I really WANT to have generated is: Any thoughts/advice? Andy -- View this message in context: http://openjpa.208410.n2.nabble.com/CriteriaBuilder-function-issue-with-MySQL-tp7581531.html Sent from the OpenJPA Users mailing list archive at Nabble.com.