I ran this script in SQL Server 2014:
SELECT FORMAT(GETDATE(), N'yyyy/MM/dd', N'fa')
But the result is a Gregorian date instead of a Persian date.
The collation is Arabic_CI_AS.
I ran this script in SQL Server 2014:
SELECT FORMAT(GETDATE(), N'yyyy/MM/dd', N'fa')
But the result is a Gregorian date instead of a Persian date.
The collation is Arabic_CI_AS.