This will returns local timestamp in the active time zone information,
with no time
zone information shown.
Ex:
SQL> select localtimestamp from
dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
24-DEC-06 03.44.18.502874 AM