From: ljb <ljb220@mindspring.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: What is the binary format for timestamps?
Date: Fri, 8 Apr 2005 01:02:07 +0000 (UTC)
Message-ID: <d34l6e$284h$1@news.hub.org> (raw)
References: <4255A00F.1010409@innovision.com>
marvin.bellamy@innovision.com wrote:
> I'm trying to read/write timestamps as binary data, but I'm getting
> garbage. It looks like there are 8 bytes of timestamp data (if I read
> the headers correctly), which I had assumed was the time in millis from
> the PostgreSQL epoch, but my values are way off. I wrote what I thought
> was valid data to my timestamp columns, but my queries in the psql
> console show (epoch?) for each one. When I read the binary content
> back, I'd expect to get 0s, but I get some non-zero values.
Don't use binary formats. But if you do:
A date is returned as a 4-byte big-endian integer representing the number
of days since POSTGRES_EPOCH_DATE.
A timestamp is returned as an 8-byte big-endian double precision number of
seconds since POSTGRES_EPOCH_DATE.
A time is returned as an 8-byte big-endian double precision number of
seconds since midnight.
POSTGRES_EPOCH_DATE is January 1, 2000 (2000-01-01).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ljb220@mindspring.com
Subject: Re: What is the binary format for timestamps?
In-Reply-To: <d34l6e$284h$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox