Previous Topic

Next topic

Print topic

Micro Focus Studio Enterprise Edition for UNIX > Programming > Data Access > Database Access > Reference > SQL Data Types > Date and Time Data Types > DATE

DATE

Data Format

If a COBOL output host variable is defined for an SQL DATE value, the date is specified in the format:

yyyy-mm-dd

For example:

1994-05-24

Host Variable Formats

OpenESQL and DB2 ECM

01 date1         PIC X(10).

OpenESQL

01 date2         SQL TYPE IS DATE.
01 date3         SQL TYPE IS DATE-RECORD.

When using the date1 format:
- OpenESQL requires that you compile applications with the DETECTDATE SQL directive.
- Move date specifications into the host variable in the form:
```
{d 'yyyy-mm-dd'}
```
The date2 format uses the DATE SQL TYPE.
The date3 format uses the DATE-RECORD SQL TYPE.

Previous Topic

Next topic

Print topic