I am looking to convert dates from my date
column in my table from the Gregorian format '12-02-2023' to Hijri (Islamic Lunar Calendar) format '01-03-1445' format.
I would like to later get results only for a particular Hijri month, lets say 9.
I have tried searching but did not get any answers that are relevant in Google Bigquery context.
Standard SQL has the 130/131 format to get Hijri dates but unsure how the application is for Bigquery.
select convert(datetime, value, 131)