Example: Using <temporal> XML

For more information, see Section 11.1.47 "Temporal Annotation" in the JPA Specification.

Timezones and Calendars

In Java a Calendar also stores a timezone and day light saving offset in addition to the date and time values. Normally this timezone is lost when storing the Calendar to the database. Some databases have support for storing timezones and offsets, so it is possible to store these to the database as well.

EclipseLink supports storing timezones in an Oracle database through the TIMESTAMPTZ and TIMESTAMPLTZ types in Oracle. To store timezones, ensure the column is of type TIMESTAMPTZ, Calendar is used as the type in Java, and the Oracle9Platform or higher is used. You can also use a TypeConverter and set the dataType to oracle.sql.TIMESTAMPTZ or oracle.sql.TIMESTAMPLTZ.