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. |
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). 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 ...
(17 Mar '20, 11:25)
Volker Barth
Replies hidden
1
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.
(17 Mar '20, 12:12)
JBSchueler
|
I wish that all of SQL Anywhere's localization capabilities were available to SQL code to enable simple translations; e.g., server messages.