Built-in Functions › DATEEXT

DATEEXT

Purpose

Returns a 10-byte external date stamp as an 8-byte internal binary date stamp.

Syntax

►►────┬─ DATE-EXTERNAL ──┬────────── (date-stamp) ────────────────────────────►◄
      ├─ DATEEXT ────────┤
      └─ DEXT ───────────┘

Parameter

date-stamp

Specifies the 10-byte representation of the date-stamp in the format CCYY-MM-DD.

date-stamp can be one of the following:

• A string literal enclosed in single quotation marks
• A name of a user-defined variable data field containing the date string

Example

In the following example, the DATEEXT function is used to convert a 10-byte string date, with the format CCYY-MM-DD, to an 8-byte binary value:

Initial value:
    DATE-FIELD: '2007-08-01'

Statement:
    MOVE DATEEXT (DATE-FIELD) TO DATE-BINARY

Returned value:
    x0165DB0000000000