Oracle 9i introduced data types and support to handle time zones. Use these data types to make your Oracle code time zone aware.
by Natalka Roshak
February 8, 2006
n our increasingly interconnected world, it's more and more important for code to be able to handle time zones gracefully. For example, if call centers in Bangalore and London use the same call center application, then the code that writes call logs to the database will have to be time zone aware—a call time recorded simply as "7:15 AM" could have happened at 7:15 AM in either London time or in Bangalore time.
Until Oracle 9i, Oracle provided a single data type for dates and times, the DATE data type, and didn't offer any special support for time zones. In Oracle 9i, Oracle provides built-in time zone and Daylight Savings Time support. Instead of trying to stuff time zone functionality into the DATE data type, Oracle introduced TIMESTAMP data types that are time zone aware.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
n our increasingly interconnected world, it's more and more important for code to be able to handle time zones gracefully. For example, if call centers in Bangalore and London use the same call center application, then the code that writes call logs to the database will have to be time zone aware—a call time recorded simply as "7:15 AM" could have happened at 7:15 AM in either London time or in Bangalore time.
