Date Time Stamp is incorrect when updating record in table
A user reported that the date timestamp when he is trying to insert or update a record in the database is not the exact time. Date is correct but somehow the time is not the exact time:
02/25/09 12:00:00.000 AM
We are using an old database version 8.1.7.4.1. I did some research and found that
The NLS settings in the session take precedence over any other settings.
The NLS settings in the client environment override the instance and database settings.
The NLS settings in the instance override the database settings.
The NLS settings in the database are used when nothing else overrides them.