Output type is not the same

[tiboun]

Given

SELECT DATE_FROM_UNIX_DATE(14238) AS date_from_epoch
;

it is translated to:

SELECT DATE_ADD(DATE '1970-01-01', INTERVAL '14238 DAY') AS date_from_epoch

But date_add returns a timestamp. Date is expected here. Expected query

SELECT DATE_ADD(DATE '1970-01-01', INTERVAL '14238 DAY')::DATE AS date_from_epoch

[tiboun]

epoch returns number of seconds but its type is float. Bigquery's type is INT64.