Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

80 Chapter 5
Application Development
Features in ALLBASE/SQL Version G3
themselves. This is an important capability for those needing to move
modules from a development DBEnvironment to a production
DBEnvironment.
Year 2000 Compatibility
ALLBASE/SQL has always stored dates in a four-digit year format
which largely eliminates the year 2000 compatibility problem.
ALLBASE/SQL applications can be coded using four-digit year dates.
However, for existing applications that may allow dates to be entered
using a two-digit year format, there is still an issue as to how these
dates get converted to the ALLBASE/SQL internal format using the
TO_DATE function or TO_DATETIME. For an explanation on how these
are handled, refer to the article, "New Features in ALLBASE/SQL
Version G3," in Chapter 10, "Technical Articles."
CAST Function
The CAST function enhancement for ALLBASE/SQL and IMAGE/SQL
became available to customers with the G1.15 release. The CAST
function is used to explicitly convert data from one data type to another.