Specifies the Open Client and Open Server datatype to which an access service converts DATE results.
DateResults=[datetime | datetime4 | char_iso | char_usa | char_eur | char_jis | char_odbc]
datetime
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_eur returns character data in the format dd.mm.yyyy.
char_jis returns character data in the format yyyy-mm-dd.
char_odbc returns character data in the format yyyy-mm-dd.
If the DATE value is outside the range of the Adaptive Server DATETIME, the DateTimeConvertError property is used to determine the desired datatype conversion.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
