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 vote222 views1 answer
Create bbox R sp
Python
0 vote342 views1 answer
Pip install scrapy-proxy-pool
Python
0 vote258 views1 answer
Mongoengine ObjectIdField
Python
0 vote254 views1 answer
Qubesos
Python
11 votes276 views1 answer
How to make an argument optional in python
Python
0 vote308 views1 answer
For loop in django template css
Python Django
0 vote240 views1 answer
Mike tyson peso pesado
Python
3 votes243 views2 answers
Auticlicker python
Python
9 votes243 views4 answers
Python combinations function
Python
0 vote276 views1 answer
Write multiple DataFrames to Excel files
Python