title: Is there a way to find or ascertain date or time format from a given value in bigquery?
body: <p>I'm trying to build a filter for date and time datatype columns which checks if all the values in that column follow the same format. Suppose we have date of birth, in Row1 it's saved as 1998-02-18 (%Y-%m-%d) and in Row2 value is 14-03-2020 (%d-%m-%Y), Row3 is 12/05/2001 (%d/%m/%Y). All are correct date formats, but I want check if they are all uniform or not. So if I have a given date, say 1998-02-18, is there any function or way to get (%Y-%m-%d) as result? that can be used to compare with other formats.</p>