Subject | Re: [Firebird-Architect] Data Stream Encoding |
---|---|
Author | Jim Starkey |
Post date | 2005-05-04T14:22:56Z |
Dimitry Sibiryakov wrote:
we're GMT+5, the first one isn't strictly what you want; we'll use
31-DEC-1969 18:59:59 instead. The one second or 1,000,000 nanoseconds
before the base date, so the physical value, an int64, is -1,000,000 or,
in hex FFF...F0BDC0. The encoding is:
edsNanoSecLen3, 0xF0, 0xBD, 0xC0.
I'll leave the others as exercises.
--
Jim Starkey
Netfrastructure, Inc.
978 526-1376
> Ok. Just to clarify this part. Could you show me how look like inOK if I do them as timestamps? Since dates are stored as GMT/Zulu and
>encoded form these dates:
>
>31-DEC-1969 23:59:59
>1-JAN-2039 0:0:0
>1-JAN-1920 0:0:0
>
>
we're GMT+5, the first one isn't strictly what you want; we'll use
31-DEC-1969 18:59:59 instead. The one second or 1,000,000 nanoseconds
before the base date, so the physical value, an int64, is -1,000,000 or,
in hex FFF...F0BDC0. The encoding is:
edsNanoSecLen3, 0xF0, 0xBD, 0xC0.
I'll leave the others as exercises.
--
Jim Starkey
Netfrastructure, Inc.
978 526-1376