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 vote132 views1 answer
Remove text between brackets python
Python
0 vote164 views1 answer
Get imaginary part of complex number python
Python
0 vote177 views1 answer
Discord embed add image
Python
0 vote169 views1 answer
Emr cluster step error ModuleNotFoundError: No module named 'torch'
Python
0 vote167 views1 answer
How to sum the revenue from every day in a dataframe python
Python
0 vote169 views1 answer
%%writefile
Python
0 vote161 views1 answer
;dslaoeidksamclsoeld,cmskadi934lglllfgl;llgldklkkkkjkklllloooofklllflll;=\f]p[
Python
0 vote165 views1 answer
Copy a df to another df
Python
0 vote167 views1 answer
Display vowels in a string using for loop
Python
0 vote162 views1 answer
Pandas fillna with median of column
Python