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 vote208 views1 answer
Pandas datetime.time
Python
1 vote234 views1 answer
Django gunicorn static file not found
Python Django
0 vote198 views1 answer
Creating a record in python
Python
25 votes226 views4 answers
How to write if statement in one line python
Python
1 vote207 views1 answer
Discord identity python html avatar
Python
1 vote181 views1 answer
Nearest neaghbor matlab
Python
0 vote178 views1 answer
Pandas parallelize for loop
Python
84 votes212 views6 answers
How to sort in pandas
Python
1 vote228 views1 answer
Django queryset multiple filters
Python
1 vote169 views1 answer
Beautiful soup how to extract from webpage
Python