Home » RDBMS Server » Server Administration » Conflicting database timestamp
Conflicting database timestamp [message #200211] Sun, 29 October 2006 05:30 Go to next message
Terry Burns
Messages: 13
Registered: January 2004
Junior Member
We have an application which is posting the wrong timestamp for database inserts. We are running 9.2.0.7 RAC on AIX 5.2

If I log into the database using sqlplus from my window machine I get the following timestamp which is 6 hours ahead (GMT)

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

SQL> select sysdate from dual;
SYSDATE
--------------------
29-OCT-2006 11:09:29

From the unix prompt I get the correct time

[143] server1:/home/oracle $ date
Sun Oct 29 05:09:53 CST 2006

When I use sqlplus from the unix prompt I get the correct time as well
SQL> select sysdate from dual;
SYSDATE
-------------------
2006-10-29 05:10:33

The dbtimezone seems to be set correctly
SQL> SELECT DBTIMEZONE FROM DUAL;
DBTIME
------
-06:00

Even when I set the dbtimezone to -12:0 or +6:0 it doesn't seem to have any affect on the timestamp.

I'm not sure why I would get the wrong timestamp using sqlplus from my work station and the correct time when I use sqlplus from the unix prompt? and how do I correct this?
Re: Conflicting database timestamp [message #200217 is a reply to message #200211] Sun, 29 October 2006 07:52 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
What is the Timezone of your PC?
Re: Conflicting database timestamp [message #200352 is a reply to message #200217] Mon, 30 October 2006 08:14 Go to previous messageGo to next message
Terry Burns
Messages: 13
Registered: January 2004
Junior Member
My PC is GMT -6
Re: Conflicting database timestamp [message #201485 is a reply to message #200211] Sat, 04 November 2006 15:16 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
It would seem that the server is innocent, right ,-)

Check Your client!
Where in the world does it think it is?
Are there any login.sql in play or similar etc.?

Br
Kim
Previous Topic: dedicated or shared server
Next Topic: Check list for oracle administration
Goto Forum:
  


Current Time: Fri Dec 09 07:35:09 CST 2016

Total time taken to generate the page: 0.10702 seconds