Using the TIMESTAMP WITH LOCAL TIME ZONE Type : Timestamp Timezone « SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL Data Types
  3. Timestamp Timezone

The TIMESTAMP WITH LOCAL TIME ZONE type extends TIMESTAMP to store a timestamp in the local time zone.

When you supply a timestamp for storage in a TIMESTAMP WITH LOCAL TIME ZONE column, your timestamp is converted-or normalized-to the time zone set for the database.

If you then retrieve the timestamp, it is normalized to the time zone set for your session.









10.11.Timestamp Timezone
10.11.1.Using the TIMESTAMP WITH TIME ZONE Type
10.11.2.Add the time zone to your TIMESTAMP clause
10.11.3.Insert data to 'timestamp with time zone' type column
10.11.4.Use 'timestamp with time zone' type column in where clause
10.11.5.'timestamp with time zone' type column
10.11.6.'timestamp with local time zone' type column
10.11.7.Insert data into 'timestamp with local time zone' type column
10.11.8.Supply a time zone region
10.11.9.Using the TIMESTAMP WITH LOCAL TIME ZONE Type
10.11.10. Use 'TIMESTAMP(4) WITH LOCAL TIME ZONE' as column type