1 year 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