Presto sequence example date

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)
;

Similar codes

0 vote120 views1 answer
Jupyter notebook check memory usage
Python
4 votes123 views1 answer
Selenium find item by class
Python
-1 vote117 views1 answer
Numpy split array into chunks of equal size
Python
0 vote153 views1 answer
Torch print floating precision
Python
2 votes124 views2 answers
Invert y axis python
Python
0 vote147 views1 answer
Django rest framework encrypt passwors
Python
0 vote125 views1 answer
Region error when use service account json file dataproc
Python
2 votes122 views1 answer
Python loop list of dictionaries
Python
20 votes112 views6 answers
Python interpreter
Python
17 votes127 views6 answers
Data types
Python