DSL.localDate() and DSL.localTime() don't work correctly on SQLite

[lukaseder]

Internally, the DSL.localDate() and DSL.localTime() methods check if the supplied data type is java.sql.Date or java.sql.Time, falling through to java.sql.Timestamp, otherwise. This is incorrect. We should check for java.time.LocalDate and java.time.LocalTime as well:

org.jooq.impl.DateOrTime:

                String name =
                      getDataType().getType() == Date.class
                    ? "date"
                    : getDataType().getType() == Time.class
                    ? "time"
                    : "datetime";

The problem also has effects on other SQL dialects, namely that the expression is erroneously named timestamp. That effect is more of a cosmetic nature.

---

See also:

• Add DataType.isDate() #8034
• Add DataType.isTime() #8036