Re: internal time format

justin <jtyme(at)intrusic(dot)com> writes:
> I'm generating binary copy files and was wondering if someone could quickly
> shed some light on the internal binary format used to represent time types,
> specifically timestamp{w/tz} types.

It's usually a float8, but an int8 if you built with
--enable-integer-datetimes. IIRC, the float8 represents seconds
before/since midnight 1/1/2000, the int8 the same but multiplied by
10^6. For timestamptz the reference is midnight GMT, for timestamp
it's, uh, just midnight ...

> pointers to which source files and/or routines to look at would
> be sufficient.

The date and time related files in src/backend/utils/adt/ are what
to look at.

regards, tom lane