bigquery date

[tiboun]

When manipulating with bigquery date function we have a date as output.

SELECT DATE_SUB(DATE '2008-12-25', INTERVAL 5 DAY) AS five_days_ago

When it gets translated to duckdb

SELECT DATE_ADD(DATE '2008-12-25', INTERVAL '-5 DAY') AS five_days_ago

duckdb returns a timestamp

SELECT typeof(DATE_ADD(DATE '2008-12-25', INTERVAL '-5 DAY')) AS five_days_ago

Expecting transpilation is :

SELECT DATE_ADD(DATE '2008-12-25', INTERVAL '-5 DAY')::DATE AS five_days_ago

[manticore-projects]

The main question is: what happens when adding a Day fraction, like adding 1 hour only.
Second question is: what happens when first parameter is a timestamp.