What happens?

DATE + INTERVAL yields DATE, not TIMESTAMP

To Reproduce

select '1977-04-20'::DATE + INTERVAL (1) SECOND ts;
-- Should produce 1977-04-20 00:00:01

OS:

OSX

DuckDB Version:

v0.9.3-dev2934 dd205d9

DuckDB Client:

CLI

Full Name:

Richard Wesley

Affiliation:

DuckDB Labs

Have you tried this on the latest main branch?

I have tested with a main build

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• Yes, I have