2 years ago
#388337

Mohammad Dayyan
Different behavior of FORMAT function, SQL Server?
I want to convert Date to PersianDate, So I'm using Format function.
It's OK at local and my Windows 10:
DECLARE @datetime DATETIME = '2022-03-16'
SELECT FORMAT(@datetime, 'yyyy-MM-dd', 'fa') -- 1400-12-25
But in our server with Windows Server 2012 R2, above query return 2022-03-16 and it ignores the culture fa!
What's wrong ?
sql-server
windows-10
windows-server-2012-r2
0 Answers
Your Answer