The PARSE-AS-SIMPLEDATE directive parses strings with datetime values to the timestamp_micros data type, which is based on the Avro timestamp_micros type.
To convert timestamp_micros to date types, see Converting Timestamp types to Date.
If you are adding a Wrangler transformation to a pipeline with BigQuery sources or sinks and you want to write to a BigQuery datetime column, use PARSE-AS-DATETIME and not PARSE-AS-SIMPLEDATE.
...