There isn't any error with Metabase 0.49.25.2 when I add 'Asia/Saigon' to the DATE() function, but when I upgrade to 0.50.36, it meets this error with Date variables
Variable name: start_date
Variable type: Date
SELECT ...
FROM ...
WHERE DATE({{start_date}}, 'Asia/Saigon')
Error:
400 Bad Request POST https://bigquery.googleapis.com/bigquery/v2/projects/aha-move-staging-348509/queries { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "No matching signature for function DATE\n Argument types: DATE, STRING\n Signature: DATE(TIMESTAMP, [STRING])\n Argument 1: Unable to coerce type DATE to expected type TIMESTAMP\n Signature: DATE(DATETIME)\n Signature accepts at most 1 argument, found 2 arguments\n Signature: DATE(INT64, INT64, INT64)\n Signature requires at least 3 arguments, found 2 arguments\n Signature: DATE(DATE)\n Signature accepts at most 1 argument, found 2 arguments\n Signature: DATE(STRING)\n Signature accepts at most 1 argument, found 2 arguments at [12:68]", "reason": "invalidQuery" } ], "message": "No matching signature for function DATE\n Argument types: DATE, STRING\n Signature: DATE(TIMESTAMP, [STRING])\n Argument 1: Unable to coerce type DATE to expected type TIMESTAMP\n Signature: DATE(DATETIME)\n Signature accepts at most 1 argument, found 2 arguments\n Signature: DATE(INT64, INT64, INT64)\n Signature requires at least 3 arguments, found 2 arguments\n Signature: DATE(DATE)\n Signature accepts at most 1 argument, found 2 arguments\n Signature: DATE(STRING)\n Signature accepts at most 1 argument, found 2 arguments at [12:68]", "status": "INVALID_ARGUMENT" }