timestamp in milli-second

  • Thread starter Thread starter Jeroen Gouma
  • Start date Start date
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
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert or update record with vba and ado 2
IPad Multiple Users 0
Changing Timestamp Settings 1
On-Line international time stamps (access DB) 1
HELP need time sheet/card calculate hours worked 1
Time Stamp 3
SQL Timestamp field for Access use 28
Timestamp Entry 1

Back
Top