Specifies the Open Client and Open Server datatype to which an access service converts to ODBC timestamp results.
DateTimeResults=[datetime | datetime4 | char_iso | char_usa | char_eur | char_jis | char_odbc]
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-hh.mm.ss.nnnnnn.
char_usa returns character data in the format mm/dd/yyyy hh:mm AM or PM.
char_eur returns character data in the format dd.mm.yyyy hh.mm.ss.
char_jis returns character data in the format yyyy-mm-dd hh:mm:ss.
char_odbc returns character data in the format yyyy-mm-dd hh:mm:ss.nnnnnn.
Use char_iso to retain the most precision.
You can convert ODBC TIMESTAMP to one of the character formats to retain more precision. CS_DATETIME has less precision (1/300ths of a second) than ODBC TIMESTAMP, which can have a precision of up to six fractional places.
A string representation of an ODBC TIMESTAMP starts with a digit and has a length of at least 16 characters. The complete string representation of an ODBC TIMESTAMP has this form: yyyy-mm-dd-hh:mm:ss.nnnnnn.
Trailing blanks can be included.
You can omit leading zeros from the month, day, and hour part of the ODBC TIMESTAMP. Also, you can truncate microseconds or omit them entirely. If you choose to omit any digit of the microseconds portion, an implicit specification of 0 is assumed.