Version 3

TIMESTAMP on Firebird

Created by: Lester Caine, Last modification: 07 Aug 2014 (16:01 UTC) by Lester Caine

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 as a fraction of a day. 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 )

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.

 

Page History
Date/Comment User IP Version
07 Aug 2014 (19:51 UTC)
Lester Caine 81.138.11.136 5
Current • Source
Lester Caine 81.138.11.136 4
View • Compare • Difference • Source
Lester Caine 81.138.11.136 3
View • Compare • Difference • Source
Lester Caine 81.138.11.136 2
View • Compare • Difference • Source
Lester Caine 81.138.11.136 1
View • Compare • Difference • Source