> 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!

See yourself :

SELECT
CAST(CAST('00:00' AS TIME) + 0 AS TIMESTAMP)
FROM
RDB$DATABASE

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info