I am facing a problem of having difference in sysdate and current_timestamp. Server date matches with sysdate but not with current_timestamp.
$ sqlplus / as sysdba
SQL*Plus: Release 188.8.131.52.0 Production on Wed May 30 16:29:04 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> SELECT CURRENT_TIMESTAMP,to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Now" from dual;