Subject Re: [Firebird-Architect] Data Stream Encoding
Author Jim Starkey
Dimitry Sibiryakov wrote:

> Ok. Just to clarify this part. Could you show me how look like in
>encoded form these dates:
>
>31-DEC-1969 23:59:59
>1-JAN-2039 0:0:0
>1-JAN-1920 0:0:0
>
>
OK if I do them as timestamps? Since dates are stored as GMT/Zulu and
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