Subject | RE: [firebird-support] Firebird timestamp data type.. |
---|---|
Author | Ken Galbraith |
Post date | 2004-11-17T12:43:55Z |
Hi Guys
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!
TIA & Regards
Ken A Galbraith
PS: Doesn't some famous (no not TFB) book mention we all come from Adam &
Eve?
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!
TIA & Regards
Ken A Galbraith
PS: Doesn't some famous (no not TFB) book mention we all come from Adam &
Eve?
> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Wednesday, 17 November 2004 11:00 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Firebird timestamp data type..
>
>
> At 12:29 PM 17/11/2004 +0100, you wrote:
>
>
> > > Can someone verify what the correct answer is so I can start recording
> my
> > > family tree (using FB) back to Roman times without getting errors
> (just
> > > joking but curious!)
> >
> >You cannot with the Firebird date/time.
>
> Well, he could if his Roman forebears were born in the Christian era.
>
> ./hb
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>