Different current_timestamp value at database server and client server
Hi,I have encountered a different current_timestamp value when I fired a SQL from server and SQL Developer.
Any idea why? I was told that the timing at the client server is different from the server, however I have checked at the Client OS level prompt by entering 'date', the value does not tally with the one at the SQL prompt. Is there any parameter which I need to alter to sync the timing?
Example:
-- date at database server.
$ date
Fri Jan 11 17:50:36 SGT 2013
-- SQL trigger at server.
SQL> select current_timestamp from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------
11-JAN-13 05.50.12.029000 PM +08:00
Any idea why? I was told that the timing at the client server is different from the server, however I have checked at the Client OS level prompt by entering 'date', the value does not tally with the one at the SQL prompt. Is there any parameter which I need to alter to sync the timing?
Example:
-- date at database server.
$ date
Fri Jan 11 17:50:36 SGT 2013
-- SQL trigger at server.
SQL> select current_timestamp from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------
11-JAN-13 05.50.12.029000 PM +08:00
0