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

2 votes259 views1 answer
Use of == python
Python
1 vote296 views1 answer
Python ndarray string array into int
Python
0 vote273 views1 answer
Replace by positions a string in a list with another string python
Python
0 vote270 views1 answer
Using built-in crawlers is very simple. A minimal example is shown as follows.
Python
0 vote270 views1 answer
Skewness python
Python
10 votes302 views3 answers
Execute linux command in python
Python
40 votes265 views3 answers
Python push to dataframe pandas
Python
0 vote351 views2 answers
Np.exp in python numpy
Python
0 vote286 views1 answer
Change command aliad
Python
0 vote250 views1 answer
Visual code notebook importerror: keras requires tensorflow 2.2 or higher. install tensorflow via `pip install tensorflow`
Python