Summary of features
- Last Updated: November 8, 2013
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
Summary of features
The following features apply to the DATETIME and DATETIME-TZ data types:
- ABL supports both
DATETIMEandDATETIME-TZin ABL data management statements such asASSIGN,UPDATE,DISPLAY,IMPORT/EXPORT; by the dynamicBUFFER-FIELDandTEMP-TABLEobjects; and by ABL functions and conversions that apply toDATEorTIME. - You can define
DATETIMEandDATETIME-TZdatabase and temp-table fields (static and dynamic). The Data Dictionary supports creatingDATETIMEandDATETIME-TZdatabase fields. - You can define a variable or field
ASaDATETIMEorDATETIME-TZvariable orLIKEaDATETIMEorDATETIME-TZdatabase field. - You can index
DATETIMEandDATETIME-TZdatabase and temp-table fields. - You can reference
DATETIMEandDATETIME-TZdata inWHEREclauses. - You can use all of the ABL constructs (
BUFFER-COPY,BUFFER-COMPARE,RAW-TRANSFER) that deal with records containingDATETIMEorDATETIME-TZdata. - You can pass
DATETIMEandDATETIME-TZparameters to local or remote procedures and user-defined functions, and as return values from user-defined functions and methods. - The default initial value for
DATETIMEandDATETIME-TZvariables or fields is theUnknown value (?). The entire value is unknown if any or all of the parts are unknown. - You can use
NOWto initialize bothDATETIMEandDATETIME-TZvariable or fields to the current system date and time. The time zone for aDATETIME-TZinitialized toNOWis the time zone of the session creating theDATETIME-TZ.