Re: ADO adDate Value Calculation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

Use floating-point

1.0 represent a whole day and fractions are from midnight, the start of a
day.

So

0.0 is 00:00:00 on a 24-hour clock
0.25 is 06:00:00 on a 24-hour clock
0.5 is 12:00:00 on a 24-hour clock
0.75 is 18:00:00 on a 24-hour clock
0.125 is 03:00:00 on a 24-hour clock
0.1 is 02:24:00 on a 24-hour clock
0.01 is 00:14:24 on a 24-hour clock
etc.

86400 seconds in a day

Stephen Howe


.

Relevant Pages

  • Re: florating point and VHDL
    ... If you really, really want floating-point hardware, there ... throw away the unused less-significant bits of the fraction, ... Jonathan Bromley, Consultant ... DOULOS - Developing Design Know-how ...
    (comp.lang.vhdl)
  • Re: is order urgent doubt
    ... Because double double (using a pair of doubles to represent a single ... floating-point number) in the general case doesn't adhere to the ... to restrict the exponents to make the fraction bits contiguous rather ...
    (comp.lang.c)
  • Re: How to "print" a "double" ?
    ... floating-point value into an integer exponent and a normalized ... fraction and printing them separately. ...
    (comp.unix.programmer)
  • Re: News on VHDL-200X
    ... p12 - Would it be more usal to call the 'fraction' of a floating-point ... The significand is similar to the fraction, ...
    (comp.lang.vhdl)
  • 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)