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 vote348 views4 answers
Mergesort
Python
7 votes361 views2 answers
Python test if string is int
Python
1 vote365 views1 answer
Jupyter notebook reload module
Python
0 vote336 views1 answer
What is iterator in python
Python
31 votes358 views6 answers
Strip whitespace python
Python
0 vote370 views1 answer
Boto3 with aws profile
Python
11 votes349 views3 answers
Group by count dataframe
Python
0 vote352 views1 answer
Python turtle set direction
Python
5 votes354 views3 answers
Python datetime last day of month
Python
0 vote366 views1 answer
Django project files
Python Django