Understanding Date Formats in BigQuery Standard SQL: A Deep Dive into Handling Non-Standard Dates and Best Practices