At 08:53 AM 10/31/2002 +1100, Alan McDonald wrote:

>Ann,
>Has this changed sometime?

No, but what we're seeing are conversions done in
the interface. Dates can be converted to floating
point - that's how they're indexed, as it happens.
I don't know whether it was InterBase or Delphi that
did the conversion, but the InterBase internal format
is two longwords.

>Also I used to see "zero" dates come up in reports as 31 Dec 1899 - when did
>this starting point change?

Ah. Whatever you were using went through the date
conversion routines. They use the Unix/C tm structure
which is uses Jan 1 1900 as its base date. It's a
wonderful thing. Doesn't recognize anything smaller
than a second. Months are zero based. Days are one
based. So year 0, month 0, day 1 is 1 Jan 1900.
Year 0, month 0, day 0 must be one day less, so...
31 Dec 1899.


Regards,

Ann
www.ibphoenix.com
We have answers.