Hello, in Struments -> Preferences -> Database -> NLS i setted all date formats, language and date language to ITALIAN
| PARAMETER | VALUE |
|---|
| NLS_LANGUAGE | ITALIAN |
| NLS_TERRITORY | ITALY |
| NLS_CURRENCY | € |
| NLS_ISO_CURRENCY | ITALY |
| NLS_NUMERIC_CHARACTERS | ,. |
| NLS_CALENDAR | GREGORIAN |
| NLS_DATE_FORMAT | DD-MON-RR |
| NLS_DATE_LANGUAGE | ITALIAN |
| NLS_SORT | WEST_EUROPEAN |
| NLS_TIME_FORMAT | HH24:MI:SSXFF |
| NLS_TIMESTAMP_FORMAT | DD-MON-RR HH24:MI:SSXFF |
| NLS_TIME_TZ_FORMAT | HH24:MI:SSXFF TZR |
| NLS_TIMESTAMP_TZ_FORMAT | DD-MON-RR HH24:MI:SSXFF TZR |
| NLS_DUAL_CURRENCY | € |
| NLS_COMP | BINARY |
| NLS_LENGTH_SEMANTICS | BYTE |
| NLS_NCHAR_CONV_EXCP | FALSE |
And after all this settings in the result query the format date was '02-JAN-19' instead of '02-GEN-19'
how to solve that?