DateResults

Specifies the Open Client and Open Server datatype to which a DB2 access service converts DB2 DATE results.

Syntax

DateResults=[datetime | datetime4 | char_iso | char_usa | char_eur | char_jis | char_odbc]

Default

datetime

Values

With Open Client version 10.0.4 and later, the default display format of CS_DATETIME for character conversions changes from a long version to a short version:

datetime returns CS_DATETIME. The range of legal values is 1/1/1753 to 12/31/9999, and a precision of 1/300 of a second.:

datetime4 returns CS_DATETIME4, a 4-byte datetime datatype with a range of legal values from January 1, 1900, to June 6, 2079, and a precision of 1 minute.

char_iso returns CS_CHAR, character data in the format yyyy-mm-dd.

char_usa returns CS_CHAR, character data in the format mm/dd/yyyy.

char_eur returns CS_CHAR, character data in the format dd.mm.yyyy.

char_jis returns CS_CHAR, character data in the format yyyy-mm-dd.

char_odbc returns character data in the format yyyy-mm-dd.