timestamp in milli-second

J

Jeroen Gouma

Hi,

we want to store time-stamps in an access database with parts of
seconds.

Is this possible in standard-Access, or do we have to create our own
time-routine?

regards,

Jeroen
 
D

Douglas J Steele

You have to create your own time routine.

Due to how the date/time variable works (it's an 8 byte floating point
number, 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), I don't believe it's possible to get better than about 3
millisecond resolution.
 
G

Guest

Jeroen Gouma said:
Hi,

we want to store time-stamps in an access database with parts of
seconds.

Is this possible in standard-Access, or do we have to create our own
time-routine?

regards,

Jeroen
Click to expand...
 
Top