CURRENT_TIMESTAMP

     This will returns the current timestamp with the active time zone information.

      Ex:

           SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP

---------------------------------------------------------------------------

24-DEC-06 03.42.41.383369 AM +05:30