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

21 votes129 views1 answer
Python remove last characters from string
Python
22 votes115 views4 answers
Palindrome checker python
Python
0 vote118 views1 answer
Second y axis matplotlib
Python
13 votes127 views2 answers
Sys get current pythonpath
Python
0 vote117 views1 answer
Create loading in pyqt
Python
-1 vote142 views1 answer
List of letter in word python
Python
0 vote185 views1 answer
Handling single exception
Python
0 vote130 views1 answer
Regrid ntdcf file usig xarray
Python
1 vote143 views2 answers
Pytorch view -1 meaning
Python
0 vote120 views1 answer
How to get one csv column in python
Python