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 vote242 views1 answer
Convert excel to json
Python
29 votes251 views2 answers
Python 1 second delay
Python
-1 vote257 views1 answer
Multiple assignment python
Python
0 vote216 views1 answer
Algorithme pour afficher table de multiplication python
Python
1 vote271 views1 answer
Separate words in a text to make a list python
Python
0 vote267 views1 answer
Dictionary Get All Keys
Python
0 vote263 views1 answer
Get image image memeory size in url inpyton requests
Python
0 vote285 views1 answer
Una esfera solida de radio 40 cm tiene una carga positiva
Python
0 vote240 views1 answer
How to not create a new line in python
Python
0 vote259 views1 answer
Py insert char at index
Python