on 2020 Mar 16 7:28 AM
Interestingly enough, I seem not to have had that need in all those years - but -
does SQL Anywhere provide names for day of week and month only in English?
Apparently, DAYNAME() and MONTHNAME() or DATEFORMAT(..., ' MMMM ') return English names only.
Request clarification before answering.
The only way to do that is to switch the "language" of the database server using the DBLANG tool.
> dblang de > dbeng17 demo.db select dayname(current timestamp) Dienstag
dblang -? will show you all of the supported languages (all 14 of them).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ah, my bad. I run our servers with the default English locale because system messages and the like are better documented and probably easier to communicate in support cases...
But I notice - somewhat contrary to your statement -, that I can use the LANG connection parameter to get localized names even when the server runs the English locale. At least using LANG=DE within DBISQL returns "Dienstag", too, as desired. And there are also the property('Language') resp. connection_property('Language') for further diagnosis of the server resp. client language...
I'm somewhat embarrassed that I have not thought of the Golden Rule ...
Now my bad. My brain must be getting a bit rusty. You are quite correct that the client can use the Language (LANG) connection parameter.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.