google-bigquery格式日期为查询结果中的mm / dd / yyyy

I am using Bigquery SQL to generate a report. The standard Bigquery date format is yyyy-mm-dd, but I want it to be formatted as mm/dd/yyyy.I am using Bigquery SQL to generate a report. T