Is there any function extracting DD/MM/YY HH:MM:SS in BigQuery to hh:mm:ss?
In the bigquery-public-data.new_york_taxi_trips.tlc_yellow_trips_2022, the dropoff_datetime and pickup_datetime are in DD/MM/YY HH:MM:SS format, and I want to find pickup_location_id and subquery.avg_duration as the following: