Acces97 - DateTime - how to set millisecond ?

F

Franck Fouache

Hi,
How to fill a datetime field by sql statement, with hours and millisecond
....
i'd like to do something like update vTable set vDate="03/10/2007
10.05.01.444" ... it works without milliseconds but i need to fill
millisecond.
Best regards.
 
D

Douglas J. Steele

The Date data type doesn't have millisecond resolution. Dates are stored as
8 byte floating point numbers, where the integer portion represents the date
as the number of days relative to 30 Dec, 1899, and the decimal portion
represents the time as a fraction of a day.

Floating point numbers are prone to round-off errors, and the number of
significant figures that can be stored depends on the size of the integer
portion. If memory serves correctly, with current dates, the best resolution
you can expect is about 3 milliseconds.
 
Top