Skip to Main Content

Software Globalization Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

October 13

18:00 UTC   Start Times Around the World


How Oracle stores datetime values and time zone file upgrades
In this session, we talked about how Oracle stores datetime values in table columns. We looked at the internal storage format of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE values. We discussed what time zone regions are and why we may need to update stored datetime values, if a new time zone file version is installed. In the next month, we will continue with description of the time zone file upgrade process.

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Sergiusz Wolicki
Sergiusz Wolicki, Database Globalization Architect    
With Oracle since August 1994. In Oracle Support until October 2005. Now providing globalization advice to DB development and developing new globalization features.
Weiran Zhang
Weiran Zhang, Director of Development
Weiran Zhang is a Director of Development, Globalization Technology for Database Globalization.