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

1 vote230 views1 answer
Strip first occurence of substring python
Python
0 vote237 views1 answer
Can you use the astro a50 with a phone
Python
0 vote231 views1 answer
Python pytest no coverage on failure
Python
17 votes259 views4 answers
Python get average of list
Python
1 vote189 views1 answer
Beautifulsoup remove element
Python
68 votes257 views5 answers
Python main method
Python
0 vote258 views1 answer
Python flatten one liner
Python
0 vote230 views1 answer
Sendgrid send email to multiple recipients python
Python
2 votes272 views2 answers
Flask 'export' is not recognized as an internal or external command, operable program or batch file.
Python
7 votes263 views5 answers
Convert categorical variable to numeric python
Python