Try OpenEdge Now
skip to main content
ABL Data Types Addenda
DATETIME and DATETIME-TZ data types
 

DATETIME and DATETIME-TZ data types

The DATETIME and DATETIME-TZ data types are also new to OpenEdge Release 10. These two ABL data types provide the following benefits (where datetime refers to DATETIME or DATETIME-TZ):
*You no longer have to manipulate dates and times separately to have datetime types of data.
*If you use DataServers, you can get direct mapping to their datetime data.
*If you do open ABL programming, you can convert your datetime data directly.
* DATETIME data type
* DATETIME-TZ data type
* Summary of features
* Related ABL functions
* SESSION handle attributes
* DATETIME and DATETIME-TZ literals
* Comparing date and datetime values
* Display formats
* DATETIME and DATETIME-TZ limits
* Datetime arithmetic
* Passing DATETIME and DATETIME-TZ as parameters
* Dumping and loading DATETIME and DATETIME-TZ fields