Hello,
I'm using Oracle 18c and SQL Developer 19.1.0.094. They run on a Windows 10 operating system.
I have some scripts that work fine in production. I also have a test system. I refresh my test system from production on a regular basis. On the test system I drop the schema and restore a copy of the production schema using IMPDP.
I have a few problems processing dates on my test system. The to_char function seems to require a different format on the test system.
In production when I run the commands:
Select value from V$NLS_Parameters where parameter = 'NLS_DATE_FORMAT';
Select sysdate from dual;
I get the results:
MM/DD/YYYY HH24:MI:SS
12/26/2019 18:43:52
However, when I run the same commands on my test system I get the results:
DD-MON-RR HH24:MI_SS
26-DEC-19 18:48:47
I suspect the different formats are what's causing the problem. I'd like to change the test system permanently so that it reflects the value set on the production system. I've read a little bit online and get multiple answers. Some suggest changing the windows registry, some suggest changing (oracle_home)/srvm/admin/init.ora.
I'd prefer to make the change once on the test system and not have to change NLS_DATE_FORMAT for every session. What do you suggest?
Thanks for your help.