Problem with name of day and month

[enriweb77]

Hi everyone, I made a query on SQL DB and the result of my alias field comes back to me in Italian.
When I view the result of the query on the page I get the resolution in English instead.
I tried to change the connect server settings by setting the timezone in OS_Default or Europe/Rome.
I also tried changing the timezone in the DB connection options but nothing changes.

Do you have any other suggestions?

[famousmag]

How do you display this values in your page?

Paste here the code please

[enriweb77]

I actually have no code, I have a Server Connect that runs the query and a label that does the data binding.

<dmx-serverconnect id="ScDate" credentials="true" url="/api/Frontend/v1/Prenotazione/date" dmx-param:uid="query.uid"></dmx-serverconnect>

{{DI_Data_Convert}}

What I noticed is that if I simulate the query from wappler the values ​​already come out in English

[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

[enriweb77]

Thanks, the suggestion N.1 work fine!!