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 vote341 views1 answer
Networkx - unique combinations of paths
Python
0 vote322 views3 answers
Matlab to python
Python
0 vote331 views1 answer
Django raw without sql injection
Python
0 vote351 views1 answer
Import CreateAPIView django
Python Django
-1 vote280 views1 answer
Muslimah coder
Python
0 vote316 views2 answers
Pandas resample friday
Python
0 vote365 views1 answer
Django serialize a get object is not iterable
Python Django
-1 vote314 views1 answer
Pandas numpy multiplicar dos columnas segun una condicion
Python
0 vote333 views1 answer
Anvil get last row of data table
Python
-1 vote353 views1 answer
Sort pandas dataframe by specific column
Python