ADO adDate Value Calculation

adDate(7) indicates a date value.
A date is stored as a double, the whole part of which is the number of days
since December 30, 1899,
and the fractional part of which is the fraction of a day.

Given a timestamp value for example 2000-12-28 09:30:00
I need to calculate the corresponding adDate Value.

I am able to calculate the number of days since December 30, 1899,
but I don't know the formula for calculating the fraction of a day.

Any idea on calculating the fraction of a day, and what is the precision of
the scale?

Thank you.


.

Relevant Pages

  • Re: relay back to table
    ... must look up each fraction on a chart before I enter some ... use Excell for SPA porpouses. ... Our company lacks nerds ... >is considerably slower than calculating it in memory. ...
    (microsoft.public.access.formscoding)
  • Re: ADO adDate Value Calculation
    ... but I don't know the formula for calculating the fraction of a day. ... Use floating-point ... Stephen Howe ...
    (microsoft.public.data.ado)
  • Re: Assembly Language - Mathematics WITHOUT maths coprocessor
    ... So I think my answer of 12.04119983 is a little more correct, as 40 bits can hold as many values as 12 decimal digits, plus just a little bit more. ... multiply by 2 ^ precision, you shift it left by precision. ... Convert fraction part to binary as if it were an integer. ... Divide fraction part by what step 4 effectively multiplied it by. ...
    (alt.lang.asm)
  • Re: Can someone please explain - real numbers
    ... (0110 recurring) and cannot ... The FPU knows how to handle repeating fractions, ... at the last available digit of precision for any given float type. ... {To start the recurring fraction immediately} ...
    (comp.lang.pascal.delphi.misc)
  • Re: scaling coefficients for c
    ... do I code a fraction in binary form for use in c code or asm language? ... have to scale your fractions to fit the range 0..255 or -128..127. ... if your microcontroller has 16 bit arithmetic, ... and the sum will be scaled by 100 also. ...
    (comp.lang.c)