DB Service TO_CHAR language format Follow
The DB services run the SQL statement on the machine on which AuraPlayer's ServiceManager is installed on.
The locale that is used, is the locale in the JVM on that machine.
If you want to specify the TO_CHAR to convert the date to specific language, then you have to specify the language in the TO_CHAR request - with the "NLS_DATE_LANGUAGE" parameter, for example in the following:
select TO_CHAR(sysdate,'DY','NLS_DATE_LANGUAGE = english') from dual
Comments
0 comments
Please sign in to leave a comment.