Displaying DATETIMEs in different languages + SQL Server 2012

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 226
FORMART() function allows you to display datetimes in various languages.... Mainly, it is very useful for the front end developers

SELECT FORMAT (GETDATE(), N'dddd MMMM dd, yyyy', 'en-US') AS English_Result;
SELECT FORMAT (GETDATE(), N'dddd MMMM dd, yyyy', 'hi') AS Hindi_Result;
SELECT FORMAT (GETDATE(), N'dddd MMMM dd, yyyy', 'gu') AS Gujarati_Result;


Output:

English_Result
Monday March 23, 2015


Hindi_Result
?????? ????? 23, 2015


Gujarati_Result
?????? ????? 23, 2015

Comments or Responses

Login to post response