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 vote99 views1 answer
Flower not implemented error
Python
1 vote113 views1 answer
How to replace a row value in pyspark dataframe
Python
1 vote128 views1 answer
Install chromedriver ubuntu python
Python
1 vote114 views2 answers
How ro have a incresing variable in python
Python
6 votes215 views6 answers
Django Redirect
Python
24 votes115 views3 answers
Get first x characters of string python
Python
69 votes125 views3 answers
How to check if character in string python
Python
0 vote121 views1 answer
Python import stringIO
Python
0 vote120 views1 answer
How to change speed in ursina
Python
24 votes126 views6 answers
Python remove white space
Python