Subject Re: [firebird-support] Firebird timestamp data type..
Author Martijn Tonies
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
> 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
> point to clarify. Is the "base" mentioned in Ann's "17 November 1858 as
> 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?

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

Define "famous" ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions