Oracle PL/SQL: TIMESTAMP: DBTIMEZONE - The dbtimezone function returns the database time zone as a time zone offset (in the following forma

Quick Search:

Oracle PL/SQL: TIMESTAMP: DBTIMEZONE

Jump to:

Category: >> Oracle PL/SQL >> TIMESTAMP: DBTIMEZONE

<< last

next >>

Snippet Name: TIMESTAMP: DBTIMEZONE

Description: The dbtimezone function returns the database time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.

If you want to change the DBTIMEZONE you will need to issue an ALTER DATBASE command.

Also see:
» FUNCTIONS: date/time
» TIMESTAMP: TZ_OFFSET
» TIMESTAMP: TRUNC
» TIMESTAMP: SysTimeStamp
» TIMESTAMP: SYS_EXTRACT_UTC
» TIMESTAMP: SessionTimeZone
» TIMESTAMP: LocalTimestamp
» TIMESTAMP: FROM_TZ
» TIMESTAMP: EXTRACT
» TIMESTAMP: DUMP
» TIMESTAMP: Get current timestamp
» TIMESTAMP: List time zones

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009

DBTIMEZONE
 
SELECT DBTIMEZONE
FROM dual;
 
-- The dbtimezone function might return a value like this:
 
    +00:00
 
-- or a value such as this:
 
    -07:00
 
 
-- change the DBTIMEZONE
ALTER database SET TIME_ZONE = 'America/Denver';
 
-- Switch back DBTIMEZONE to hh:mm format
ALTER database SET TIME_ZONE = '-07:00';
 
 
-- Create table with different TIMESTAMP columns
CREATE TABLE date_table (
       time_stamp_tz   TIMESTAMP WITH TIME ZONE,
       time_stamp_ltz  TIMESTAMP WITH LOCAL TIME ZONE);