This post is older than a year. Consider some information might not be accurate anymore.
If you are working with Oracle you may experience unexpected behaviors considering your Oracle’s National Language Support (NLS). Some SQL statements to setup properly for your working session.
SQL> ALTER SESSION SET NLS_LANGUAGE=ENGLISH;
Session altered.
SQL> ALTER SESSION SET NLS_TERRITORY=SWITZERLAND;
Session altered.
SQL> select current_timestamp from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
15.11.16 07:38:20.420000 +01:00
