I'm not 100% certain about this, but according to this
] SQL server only supports Greogrian Dates. This makes some sense as al-Hijri is one of the few calendars that doesn't follow the solar year and the difficulty where lunar observations are applied. You can change a UTC date to a Hijri on using the cast/convert
] functions if you want, but it's probably better to store do everything on the SQL server side in UTC, and write a function to convert to al-Hijri on the client.