'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 ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
