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

0 vote252 views1 answer
Sum the contents of a list python
Python
0 vote290 views1 answer
Change group box title font size
Python
0 vote269 views1 answer
How to store in parquet format using pandas
Python
8 votes264 views3 answers
Python add zero to string
Python
0 vote253 views1 answer
How to access python list
Python
0 vote268 views1 answer
Ssl server python
Python
14 votes272 views3 answers
Change key of dictionary python
Python
0 vote290 views1 answer
Items of a list not in another list python
Python
-1 vote281 views1 answer
Function TBone() if 2=2 then print("Sup") end
Python
0 vote305 views1 answer
How to import flask restful using pip
Python Flask