A script-enabled browser is required for this page to function properly.

About DATETIME Items

Values for Forms items with data type DATETIME are automatically converted between the server time zone region for the value stored in the Forms record manager, and the local time zone region for the value in the client's widget.

This conversion does not apply to items of data type DATE.

Time zone conversions take into account historical data when transitions between daylight and standard time have occurred (or are anticipated to occur) in the relevant time zone regions. This historical data is extracted from the time zone file (FORMS_TZFILE).

An automatic conversion of an ambiguous DATETIME item value (because it falls into the 2-hour overlap period that occurs once a year when switching from daylight back to standard time) assumes that the ambiguous value represents standard time.

About Automatic Conversion of DATETIME Items

There are special considerations regarding the automatic conversion of DATETIME item values in a block that's in Enter-Query mode. Item values entered by the end user in enter-query mode will be time-zone adjusted (to produce the value used in the query's WHERE clause) when the value is:

Item values entered by the end user in Enter-Query mode are not time-zone adjusted (to produce the value used in the query's WHERE clause) when the value is:

Item values set programmatically by the COPY Built-in are time-zone adjusted (to produce the value used in the query's WHERE clause) only when the value is:

Full DATETIME item values that are set programmatically by a PL/SQL assignment are not time-zone adjusted

Note: :SYSTEM.LAST_QUERY always shows DATETIME values in the server's time zone.


Datetime_Server_TZ Property

Datetime_Local_TZ Property

FORMS_DATETIME_LOCAL_TZ

FORMS_DATETIME_SERVER_TZ

ADJUST_TZ Built-in

FORMS_TZFILE