Specifies the Open Client and Open Server datatype to which an access service converts ODBC TIMESTAMP results.
DateTimeResults=[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-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 the following 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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
