How to convert datetime in Persian in SQL Server

Question

I want to convert my datetime into Persian datetime in SQL Server. My datetime is in MM/DD/YYYY format. Is there any function in SQL Server to do this as when I want hijri datetime I use this

 SELECT CONVERT(VARCHAR(40), GETDATE(), 131) -- Output is 14/08/1432 5:02:01:197PM  

I'm using SQL Server 2008.

Answer 1

Best method in SQL Server 2016

Example:

SELECT FORMAT(GETDATE(), 'yyyy/MM/dd-HH:mm:ss', 'fa')

Answer:

1398/10/08-05:37:59