10.3. Using Datetime Datatypes
A challenge in managing data in a global environment is synchronizing transactions that occur across time zones. Oracle's globalization support offers special datatypes and functionality to manage dates and times across differing time zones.
In the following sections, you'll learn about the Oracle datatypes that store date and time information. The data stored using these datatypes are often called datetimes, and you'll learn about the following:
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
You'll also be introduced to several datetime SQL functions. Lastly, time zone parameters and files will be covered.
10.3.1. DATE Datatype
The DATE datatype is used to store date information as well as ...