BQ datetime_trunc

[tiboun]

Translating

SELECT
    DATETIME '2008-12-25 15:30:00' as original,
        DATETIME_TRUNC(DATETIME '2008-12-25 15:30:00', DAY) as truncated;

returns

SELECT DATETIME '2008-12-25 15:30:00' AS original, DATE_TRUNC('DAY', DATETIME '2008-12-25 15:30:00') AS truncated

which results as a date once date_trunc is applied. date_trunc returns either a timestamp or a date depending on the granularity provided. Maybe we should transform it to a datetime once done if bigquery function is datetime_trunc

SELECT DATETIME '2008-12-25 15:30:00' AS original, DATE_TRUNC('DAY', DATETIME '2008-12-25 15:30:00')::DATETIME AS truncated

[tiboun]

This applies as well to timestamp_trunc.