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

3 votes188 views1 answer
List in python 3
Python
0 vote201 views1 answer
ImportError: OpenCV loader: missing configuration file: ['config.py']. Check OpenCV installation.
Python
0 vote179 views1 answer
Pytorch squeeze
Python
0 vote182 views1 answer
Semaphore in python
Python
0 vote203 views4 answers
Python to php
Python
2 votes183 views1 answer
Django template tag to display current year
Python
1 vote196 views1 answer
Python discord discord.py disable remove help command
Python
0 vote180 views1 answer
Create pdf from bytes python
Python
0 vote184 views1 answer
How to add scrollbar to listbox in tkinter
Python
0 vote184 views2 answers
Pandas read csv skip first line
Python