Problem with name of day and month

[famousmag]

Two suggestions:
1) Server-side
With the FORMAT() you can define language…
SELECT FORMAT (getdate(), 'dddd, MMMM, yyyy','es-es') as date --Spanish
Check here:

Format SQL Server Dates with FORMAT Function

2) Client-side by usinf moment.js:
-Your SQL contains only the actual date,
-create a custom formatter as described here:

How to get date with st nd or th using formatdate

Here a custom formatter that uses moment.js for formatting the date. Place following script in a js file or script block: dmx.Formatter('string', 'formatDate2', function(val, format) { return moment(val).format(format); }); Now use it like: {{ next_birthday.formatDate2("dddd, MMMM Do YYYY") }}

and use the formatter to display the formatted date in your page