Subject RE: [firebird-support] Firebird timestamp data type..
Author Ken Galbraith
Hi Martijn

> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: Wednesday, 17 November 2004 11:52 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Firebird timestamp data type..
>
>
> Hello Ken,
>
> > Thanks (Martijn & Helen) I had an attack of "cognitive dissonance" & was
> > thinking day "zero" had to be the same as the 1st date that can be
> recorded
> > in a FB DB. Of course the quote from your (Helen's) book mentioned it
> was
> > stored in a "signed" 32 bit integer which should have clicked.
> >
> > Now being pedantic (pre-requisite for all decent programmers) I have 1
> last
> > point to clarify. Is the "base" mentioned in Ann's "17 November 1858 as
> the
> > base of FB's DATE", base 0 or base 1 (when I went to school we learned
> to
> > count from 1) or in other words, is it the 16 November 1858 or the 17
> > November 1858 which has the honour of being stored in FB as 0 (zero)?
> >
> > This is a serious question!
>
> Seriously: does it matter? And if so, I'd ask: why?

To me it's a serious question, possibly for the same reason as the current
millennium didn't start until January 1, 2001 since there was no year 0 AD,
meaning I just like to know exact answers not approximate! (Yes as I said,
I'm pedantic about things)

>
> > TIA & Regards
> >
> > Ken A Galbraith
> >
> > PS: Doesn't some famous (no not TFB) book mention we all come from Adam
> &
> > Eve?
>
> Define "famous" ;-)

AFAIK there have been more copies of the "bible" printed than any other
book, but I'm sure you know that. That should be one definition of famous.

>
> With regards,
>
> Martijn Tonies

Regards

Ken A Galbraith