DateResults

Specifies the Open Client and Open Server datatype to which an access service converts to date results.

Syntax

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

Default

datetime

Values

datetime returns an 8-byte datetime datatype with a range of legal values from January 1, 1753 to December 31, 2079, and a precision of 1/300th of a second (3.33 milliseconds).
datetime4 returns a 4-byte datetime datatype with a range of legal values from January 1, 1900 to June 6, 2079, and a precision of one minute.
char_iso returns character data in the format yyyy-mm-dd.
char_usa returns character data in the format mm/dd/yyyy.
char_eurreturns character data in the format dd.mm.yyyy.
char_jisreturns character data in the format yyyy-mm-dd.
char_odbc returns character data in the format yyyy-mm-dd.

Comments

If the DATE value is outside the range of the Adaptive Server DATETIME, the DateTimeConvertError property determines the desired datatype conversion.