wren-engine icon indicating copy to clipboard operation
wren-engine copied to clipboard
Published 2 weeks ago • verified publisher icon Canner

BigQuery dry run can not detect TIMESTAMP +/- INTERVAL

Open grieve54706 opened this issue 1 year ago • 0 comments

Describe the bug BigQuery dry run can not detect TIMESTAMP +/- INTERVAL with non-zero MONTH or YEAR

TIMESTAMP +/- INTERVAL is not supported for intervals with non-zero MONTH or YEAR part.

To Reproduce Go BigQuery page then execute SELECT CURRENT_TIMESTAMP - INTERVAL '3' MONTH

Screenshots image

grieve54706 avatar Oct 28 '24 03:10 grieve54706