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

83 votes164 views6 answers
Activate venv windows
Python
0 vote154 views1 answer
Python list inster 0
Python
0 vote155 views1 answer
Pandas read csv dtype list
Python
0 vote111 views1 answer
Solve ax=0 python
Python
0 vote165 views2 answers
How to take unknown number of inputs in python
Python
0 vote154 views1 answer
Build mac app from python script
Python
12 votes154 views1 answer
Copy a dict in python
Python
0 vote155 views1 answer
Programmer tool
Python
4 votes153 views1 answer
Remove multiple space python
Python
1 vote151 views1 answer
Plot normal distribution python
Python