SQL ( Bigquery ) Compare Two Dates on Where Condition

Job ID: 34996748

Budget: ₹12,500 – ₹37,500 INR

On GCP Bigquery, can you compare two dates? ex: 22102022 ( Its in Character format as of now ).

Related categories: SQL Oracle MySQL Microsoft SQL Server BigQuery