Hello All, I am wondering if something changed with the format clause for the CAST function in BQ as I have run the following statement in the past and it worked. Now I get this error: Failed to parse input timestamp string at 5 with format element ‘MM’ SELECT CAST(col AS DATE FORMAT ‘YYYY.MM.DD…

Nothing has changed for the CAST function syntax. The month portion of your date string is probably empty or exceeds 2 characters. Better use SAFE_CAST if this is just a minor case in your data source.

CAST function

Google Cloud Data Analytics

NorieRam September 19, 2024, 3:23pm 9

Hi @awilly ,

I’m glad the adjusted query worked for you. Thanks for the update!

Topic		Replies	Views
[BigQuery] Regarding Conversion String to Date Type Issue Data Analytics bigquery	6	501	September 16, 2024
Failed To Parse Input String Data Analytics bigquery	1	137	November 23, 2022
Convert String (yyyy-mm-dd) to Date field Looker bigquery , lookml	1	98	August 25, 2022

CAST function

AI Suggested topics