Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

Using the TIMESTAMP WITH LOCAL TIME ZONE Type

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.