@ExcludeIn({CUBRID, DERBY, HSQLDB, SQLITE, TERADATA})
public void Date_Diff2() {
TestQuery query = query().from(employee).orderBy(employee.id.asc());
LocalDate localDate = new LocalDate(1970, 1, 10);
Date date = new Date(localDate.toDateMidnight().getMillis());
int years = query.singleResult(SQLExpressions.datediff(DatePart.year, date, employee.datefield));
int months = query.singleResult(SQLExpressions.datediff(DatePart.month, date, employee.datefield));
// weeks
int days = query.singleResult(SQLExpressions.datediff(DatePart.day, date, employee.datefield));