Convert legacy sql to standard sql - Big Query

Question

I got the following error in big query when running the following code in standard SQL:

SELECT 
    DATE(DATE_ADD(TIMESTAMP("2017-10-01"), pos - 1, "DAY")) AS selected_date
FROM
    (SELECT 
         ROW_NUMBER() OVER() AS pos, *
     FROM 
         (FLATTEN((SELECT SPLIT(RPAD('', 1 + DATEDIFF(TIMESTAMP(CURRENT_DATE()), TIMESTAMP("2017-10-01")), '.'),'') AS h
     FROM (SELECT NULL)),h
     )))

Error:

Syntax error: Expected keyword JOIN but got ")" at [7:7]

Can anyone convert this to standard SQL?

Mikhail Berlyant · Accepted Answer · 2017-11-20 13:20:29Z

3

#standardSQL
SELECT d AS selected_date
FROM UNNEST(GENERATE_DATE_ARRAY("2017-10-01", CURRENT_DATE())) d

answered Nov 20, 2017 at 13:20

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mikhail Berlyant Over a year ago

great. if not yet - consider voting up :o)

Collectives™ on Stack Overflow

Convert legacy sql to standard sql - Big Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related