TimeResults

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

Syntax

TimeResults=[ 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, 9999, 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 hh.mm.ss.

  • char_usa returns character data in the format hh:mm AM or PM.

  • char_eur returns character data in the format hh.mm.ss.

  • char_jis returns character data in the format hh:mm:ss.

  • char_odbc returns character data in the format hh:mm:ss.nnnnnn.