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

20 votes145 views2 answers
How to create string in python
Python
0 vote143 views1 answer
Discordpy make all inputs lowercase
Python
15 votes144 views1 answer
Format to 2 or n decimal places python
Python
4 votes160 views5 answers
How to take multiple integer input in python
Python
1 vote165 views1 answer
Python alphabet to number
Python
0 vote133 views1 answer
Python IDLE Shell Run Command
Python
3 votes105 views1 answer
Torch view
Python
0 vote150 views1 answer
Draw figure larger than plot
Python
11 votes141 views6 answers
Drop null rows pandas
Python
0 vote133 views1 answer
Featch detail of subscription in stripe api
Python