Hello, today i didn't find a way to create this kind of query with jooq (Mysql) :
"select avg(floor(datediff(date1,date2))-someinteger) from table;" date1 & date2 being DATETIME type and someinteger an INTEGER. DATEDIFF() returns expr1 – expr2 expressed as a value in days from one date to the other. expr1 and expr2 are date or date-and-time expressions.
