Re: what is the date format in binary query results

Samantha Atkins <sjatkins@mac.com> writes:
> What can I expect for a date format from a PGresult containing binary
> results?  Specifically the Oid type is TIMESTAMPTZOID.

It's either an int8 representing microseconds away from 2000-01-01
00:00:00 UTC, or a float8 representing seconds away from the same
origin.

            regards, tom lane