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

8 votes258 views2 answers
Django create empty migration
Python
17 votes272 views6 answers
Convert numpy array to dataframe
Python
2 votes266 views1 answer
Python - prime number generator
Python
3 votes227 views2 answers
Adjust tick label size matplotlib
Python
2 votes260 views2 answers
Pandas replace null values with values from another column
Python
6 votes256 views2 answers
Python file to array
Python
1 vote252 views1 answer
Last 24 hour python datetime
Python
0 vote234 views1 answer
Tkinter fixed window size
Python
2 votes275 views2 answers
Python longest list in list
Python
0 vote258 views1 answer
Read stripped lines from a file python
Python