cast to date time to date big query code example

Example: cast to date bigquery

#standardSQL
SELECT PARSE_DATE('%m/%d/%Y',  '6/22/2017')


2017-06-22