SELECT CAST(date_column AS DATE) date_column FROM (VALUES (SEQUENCE(FROM_ISO8601_DATE('2010-01-20'), FROM_ISO8601_DATE('2010-01-24'), INTERVAL '1' DAY) ) ) AS t1(date_array) CROSS JOIN UNNEST(date_array) AS t2(date_column) ;