'STRING - DATE FORMAT BIGQUERY

error is : Invalid timestamp: '2/17/2022'

Hi guys, Someone can help me to change STING (dd-mm-yyy) to a Date fomat (yyyy-mm-dd)?

thank you for your time

Solution 1:^[1]

Try below

select parse_date('%m/%d/%Y', '2/17/2022'), parse_date('%m-%d-%Y', '2-17-2022')

with output

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Mikhail Berlyant