-
Enhancement
-
Resolution: Done
-
Minor
-
1.5.0.Final
-
None
-
False
-
False
-
Undefined
-
Various integration tests in the oracle connector are failing when they are run by a client with a language setting other than english.
The NLS settings of the connecting session is determined by the clients language setting. Some format elements (e.g. MON) translate to different values depending on the NLS settings.
For example, the following function call in SQL will throw an exception (ORA-01858) if the language of the session does not know a month MAR
TO_DATE('27-MAR-2018', 'dd-MON-yyyy')
For all dates literals in SQL statements I therefore suggest to use the ANSI format yyyy-mm-dd. In fact it would be even possible to use the shorter ANSI date literal in a lot of situations (e.g. DATE'2018-03-27' instead of TO_DATE('2018-03-27', 'yyyy-mm-dd'), but to be consistent in the whole code base I think it's probably better to stick to using the TO_DATE function.