[V1] Complete datetime and interval types

[rchowell]

Description

PartiQL does not implement the SQL datetime operators; here's what needs to be done: see SQL-99 4.7.3 p.29.

Working PR – #1656

Tasks

• Define datetime on datum
• Define interval on ptype
• Define interval on datum
• Add INTERVAL_YM and INTERVAL_DT to PTYPE
• datetime - datetime -> interval
• datetime + interval -> datetime
• datetime - interval -> datetime
• interval + datetime -> datetime
• interval + interval -> interval
• interval - interval -> interval
• interval * numeric -> interval
• interval / numeric -> interval
• numeric * interval -> interval

[rchowell]

Awaiting PR feedback on additions to Datum before fixing the build hence still draft. Fixing the builtin functions will be a lot of work which is subject to change based upon the modeling.

[rchowell]

need rebase on #1658

[rchowell]

After that, I'll address the build. Working on plans now.

[alancai98]

Adding INTERVAL was attempted in #1656. A potential lesson learned is that Java's duration and period may not properly model SQL's INTERVAL semantics. Still need some further investigation here. We may need to introduce a separate class to model properly.