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

4 votes86 views3 answers
How to install python on visual studio code
Python
11 votes117 views4 answers
Python get random character from string
Python
0 vote94 views2 answers
Unable to import wx
Python
0 vote101 views1 answer
Import all images from folder python
Python
52 votes89 views3 answers
How to make a venv python
Python
2 votes102 views1 answer
How to load ui file in pyqt5
Python
69 votes98 views3 answers
Puthon for loop
Python
0 vote99 views1 answer
How to add list toa key in ict
Python
0 vote124 views1 answer
Send arrays over POST by Python requests library
Python
0 vote96 views1 answer
Python sum of 10 numbers from user input
Python