Database Administration (MOSC)

MOSC Banner

Getting wrong date on timestamp datatype

edited Mar 23, 2015 10:03AM in Database Administration (MOSC) 9 commentsAnswered

I'm selecting ntimestamp# from sys.aud$ and the time received is wrong. I get wrong time when I select from my pc and when I select directly with sql from the database server.

SQL> select dbtimezone from dual;

DBTIMEZONE
------------------
+02:00

+2 is the correct.

How do I fix this problem?

Thanks in advance.

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