Database Administration (MOSC)

MOSC Banner

Date Time Stamp is incorrect when updating record in table

edited Jun 24, 2009 3:42PM in Database Administration (MOSC) 2 commentsAnswered
 Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center