SQL sysdate appears different format than our NLS_DATE param.
467595Jun 16 2006 — edited Jun 21 2006I have a production server that alternates the sysdate format during different connections.
SQL> select sysdate from dual;
SYSDATE
-------------------------------------------------
2006-06-16 19:35:15
My NLS_DATE format is: DD-MON-RR HH24MI
Other workstations show either the correct date format, or this invalid format 2006-06-16 19:35:15.
What would cause this difference? The only way we found to reset the date format was to shutdown the database and restart it. This is a persistant error, any help is greatly appreciated!