Convert Hijri date to Gregorian date

Help Connectors and Pipelines
1

I want to convert hijri date to gregorian date but could not find any function in memsql. Is there any way we can do that?

2

There’s no built-in way to do this but if you really want to do it from SQL then you could write your own built-in UDF to do it if you can find the algorithm to do it & translate it to a SingleStore UDF.

Alternatively, you could use an external function to write this UDF in, say, Python (hijri-converter · PyPI) or Java (java - converting gregorian to hijri date - Stack Overflow) using already-written Python or Java implementations.