Subject | Re: [firebird-support] Firebird timestamp data type.. |
---|---|
Author | Martijn Tonies |
Post date | 2004-11-17T12:51:54Z |
Hello Ken,
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Thanks (Martijn & Helen) I had an attack of "cognitive dissonance" & wasrecorded
> 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 waslast
> 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 asthe
> base of FB's DATE", base 0 or base 1 (when I went to school we learned toSeriously: does it matter? And if so, I'd ask: why?
> 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 & RegardsDefine "famous" ;-)
>
> Ken A Galbraith
>
> PS: Doesn't some famous (no not TFB) book mention we all come from Adam &
> Eve?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com