%i is not an option. https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements#format_elements_date_time https://cloud.google.com/bigquery/d

%i is not an option. https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements#format_elements_date_time https://cloud.google.com/bigquery/docs/reference/standard-sq... Looking it up it's only used in really old DBs. ...but that table reveals I should have used %M instead of %m. Whoops! Although in this particular case it doesn't make a difference. And apparently I can do "%F %X" instead of the whole string.