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