After the DataServer connects to Oracle, it issues the following statements to set National Language Support (NLS) parameters for the Oracle environment:
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD'
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
These settings might affect how stored procedures (including those using the send-sql-statement option) behave. Specifically, the default format that the TO_DATE function and the format of a date returned might be different. Always specify the format for the date as the second argument to the TO_DATE and TO_CHAR functions when dealing with date values.
