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

13 votes192 views3 answers
Python how to generate random number in a range
Python
0 vote188 views1 answer
How to install arcade in python
Python
-1 vote216 views2 answers
Python main template
Python
0 vote240 views1 answer
Type object 'SparkContext' has no attribute '_jsc'
Python
7 votes203 views3 answers
Python set cwd to file location
Python
-1 vote201 views1 answer
Print "hi"
Python
0 vote220 views1 answer
Alan watts
Python
1 vote203 views1 answer
Add year to id django
Python
1 vote208 views1 answer
Scrapy get inside attribute value
Python
1 vote215 views1 answer
Simple time in python
Python