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 vote182 views1 answer
Jupyter notebook not showing all null values
Python
0 vote206 views2 answers
Knapsack problem using greedy method in python
Python
9 votes212 views2 answers
How to read video in opencv python
Python
0 vote207 views1 answer
Sqlalchemy filter getattr
Python
0 vote257 views1 answer
No module named 'bootstrap4' django
Python Django
0 vote187 views3 answers
Module_param char
Python
1 vote239 views6 answers
Tuples in python
Python
0 vote194 views2 answers
Change markersize in legend matplotlib
Python
-1 vote213 views1 answer
Pytube3
Python
0 vote207 views1 answer
Customizable TKinter Buttons Python
Python