1 year ago

#388337

test-img

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

Accepted video resources