TIMESTAMP on Firebird

Created by: Lester Caine, Last modification: 07 Aug 2014 (19:51 UTC)

Need to dig out the notes on just how a TIMESTAMP works in Firebird. It is essentially two 32 bit numbers, one being the date and the other time which I thought was a fraction of a day, but is apparently stored as a 100mS count.

The date element runs from January 1,100 AD to February 28, 32768 AD. The '0' date is November 17, 1858 and caclulations on date ranges prior to that are done with -ve numbers. This is based on the VMS operating system that the code originated in. ( Jim's post on that + and also )

http://www.firebirdsql.org/en/firebird-date-literals/ for the conversion to convential date formats ...

The time element was originally only returning seconds, but later developments provided the option for millisecond accuracy.
https://www.ibphoenix.com/resources/documents/design/doc_169 provides the fine

Some more historic material will be added later.