2009/02/04-10:49:12.229510 Any hope of doing math?

[Rich]

Any hope of doing math on this level of precision or do I need to break into
tiny bitesize pieces for Access?

Need to do this in SQL. Don't know if the serial format of the date is
compatible with the decimal fomat above. If so, I suspect it would be
simple, but haven't figured out yet how to get it into the serial format.
Seems help from my Access installation keeps forcing me to the MS website
which is almost useless.

thanks in advance,

Rich

 

[John W. Vinson]

Any hope of doing math on this level of precision or do I need to break into
tiny bitesize pieces for Access?

Need to do this in SQL. Don't know if the serial format of the date is
compatible with the decimal fomat above. If so, I suspect it would be
simple, but haven't figured out yet how to get it into the serial format.
Seems help from my Access installation keeps forcing me to the MS website
which is almost useless.

thanks in advance,

Rich

Access Date/Time fields are stored as a Double Float number, a count of days
and fractions of a day (times) since midnight, December 30, 1899. As such they
are *capable* of storing times to a few microseconds (it's been about 3.44
billion seconds since then).

HOWEVER - you can't actually display a date/time field to any precision below
one second. The data's there but you can't really get at it.

What you may need to do is store the time in double precision seconds (about
14 decimal places) and parse it out into this format yourself. What's the
nature of the data being stored?