SYSTIMESTAMP

     This will returns the system date, including fractional seconds and time zone of the

      database.

      Ex:

           SQL> select systimestamp from dual;

SYSTIMESTAMP

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

24-DEC-06 03.49.31.830099 AM +05:30