Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; _WikiDiffEngine has a deprecated constructor in /srv/website/_bw4/util/includes/diff.php on line 40
Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; WikiDiff has a deprecated constructor in /srv/website/_bw4/util/includes/diff.php on line 441
Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; WikiDiffFormatter has a deprecated constructor in /srv/website/_bw4/util/includes/diff.php on line 763
Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; WikiUnifiedDiffFormatter has a deprecated constructor in /srv/website/_bw4/util/includes/diff.php on line 931
Deprecated: assert(): Calling assert() with a string argument is deprecated in /srv/website/_bw4/util/includes/diff.php on line 335
Deprecated: assert(): Calling assert() with a string argument is deprecated in /srv/website/_bw4/util/includes/diff.php on line 335
Warning: Cannot modify header information - headers already sent by (output started at /srv/website/_bw4/liberty/content_history_inc.php:58) in /srv/website/_bw4/kernel/BitSystem.php on line 419
Warning: Cannot modify header information - headers already sent by (output started at /srv/website/_bw4/liberty/content_history_inc.php:58) in /srv/website/_bw4/themes/BitThemes.php on line 2109 - History of Time
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 + ((Base Date - 17-Nov-1858|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.