get date as persian date if support on windows (the server which sql-server is installed) : SELECT FORMAT(GETDATE(), N'yyyy/MM/dd-HH:mm:ss', N'fa')