Database Administration (MOSC)

MOSC Banner

Timestamp changes after enteriing or leaving DST

edited Mar 26, 2012 5:27AM in Database Administration (MOSC) 1 commentAnswered
 I have a strange problem. In a few schema's the timestamp changes one hour after entering (or leaving) DST. Not schema''s are affected, but also not all timestamps in the affected schema's.
The timestamps ususally have a time of '00:00', but they change to one hour earlier: '23:00' after going to DST. But not all times. There seems to be a few time periodes for which this occurs: dates between 1940 and 1945 and dates between 1976 and 1979.

The current NSL settings have been attached.

Other information: Oracle server: v10.2.0.4.0.

Does someone have any idea what's the cause of this issue.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center