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