Database Reference
In-Depth Information
Table 16.1
Oracle Simple Datatypes. (continued)
Valid dates range from January 1, 4712
.
. to December 31,
B
C
9999
. Oracle stores DATE datatype values internally as 7-
byte numbers including the time in hours, minutes, and sec-
onds. If no time is specified when inserting a date, the time is
set to midnight.
.
A
D
TIMESTAMP(p)
p = fractions of a second
TIMESTAMP(3)
Same range as a DATE datatype, except this contains fractions
of a second. For example, TIMESTAMP(4) has precision to 1/
1000th of a second.
TIMESTAMP(p)
WITH TIME ZONE
p = fractions of a second
TIMESTAMP(4) WITH
TIME ZONE
Same as TIMESTAMP except the value includes the time zone
of the user that inserts or updates the value.
TIMESTAMP(p)
WITH LOCAL TIME
ZONE
p = fractions of a second
TIMESTAMP(4) WITH
LOCAL TIME ZONE
Same as TIMESTAMP except the value converts the date to
the time zone of the database, and displays the time in the
local time zone for the viewer.
ROWID
None
ROWID
Internal Oracle datatype that stores the physical locator string
or logical pointer for a row of data.
UROWID
None
Universal ROWID. Hexadecimal string containing ROWID
values for an index-organized table, object table, or non-Ora-
cle entity. Can be up to 4,000 bytes.
BINARY_FLOAT
None
BINARY_FLOAT
32-bit binary precision floating-point number including val-
ues for infinity and NaN. NaN means “not a number.”
BINARY_DOUBLE
None
BINARY_DOUBLE
64-bit binary precision floating-point number including val-
ues for infinity and NaN. NaN means “not a number.”
