google-bigquery format date as mm/dd/yyyy in query results : <p>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.</p>

<p>Is there a way via Bigquery SQL to convert the date format on SELECT?</p>

<p>Thanks in advance,</p>
