How do I convert a string yyyy/mm/dd to date in bigquery?
<p>I'm currently selecting a column from a table where the datatype is a string (format yyyy-mm-dd). However, if I select it, the content of what I selected changes. This is what I am currently writing: </p>

<pre><code>select 
timestamp(changeMadeDate) as newDate,
eventType,
parameters_name,
membershipstatus,
gender,
platform,
f0_


from reports_temp.tk0415
where parameters_value = 'true'
or parameters_value = 'false'
</code></pre>