Re: What is the binary format for timestamps?

On Fri, Apr 08, 2005 at 01:02:07 +0000,
  ljb <ljb220@xxxxxxxxxxxxxx> wrote:
> 
> 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).

I believe building with --enable-integer-datetimes will change this.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)