How do I convert Gregorian date into Persian date (Jalali) in SQL? [duplicate]

Question

I want to convert the Gregorian date to Persian in the following code

select  cast(dateGregorian as persianDate) date
from order
where orderid = ?

Answer 1

Use this solution

select  FORMAT(dateGregorian ,'yyyy/MM/dd','fa') date
from order
where orderid = ?