1)

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. f) DBTIMEZONE. This will returns the current database time zone in UTC format. (Coordinated Universal Time) Ex: SQL> select dbtimezone from dual ... ................
................