Dates in Oracle Applications
There are two main
ways that dates are stored in the applications: as character strings or as
binary, Julian dates. Dates, both as character strings and as Julian dates, are
used in various places in the applications, including database tables, C and
Pro*C code, PL/SQL versions 1, 2, and 8, concurrent programs, Oracle Reports,
Java code, flexfield columns, form fields, and profile values.
Before continuing the
discussion of how dates are used in Oracle Applications, it is helpful to
establish some definitions.
