|Subject||Re: [firebird-support] Firebird timestamp data type..|
> 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 toSee yourself :
> 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!
CAST(CAST('00:00' AS TIME) + 0 AS TIMESTAMP)
Firebird open source database (based on IB-OE) with many SQL-99 features :
Support list for Interbase and Firebird users :
Nederlandse firebird nieuwsgroep :