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 vote152 views1 answer
Discord.File(fp=image_binary,filename=name) discord py
Python
5 votes160 views2 answers
Which language written python
Python
26 votes152 views4 answers
Python ceiling
Python
9 votes136 views1 answer
Mac upgrade python to 3.8
Python
0 vote146 views1 answer
NotImplementedError: cannot instantiate 'PosixPath' on your system fast ai
Python
0 vote154 views1 answer
Issue AttributeError: ‘numpy.ndarray’ object has no attribute ‘index’
Python
12 votes192 views3 answers
Python datetime day of year
Python
40 votes142 views6 answers
Pandas reset index
Python
1 vote152 views1 answer
Python how to sort by date
Python
1 vote107 views1 answer
Make each element in a list occur once python
Python