Quick Links

Re: what is the date format in binary query results

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Samantha Atkins <sjatkins(at)mac(dot)com>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: what is the date format in binary query results
Date:	2007-11-08 15:18:58
Message-ID:	24529.1194535138@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Samantha Atkins <sjatkins(at)mac(dot)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

In response to

what is the date format in binary query results at 2007-11-08 05:01:43 from Samantha Atkins

Responses

Re: what is the date format in binary query results at 2007-11-08 15:59:25 from Reg Me Please
Re: what is the date format in binary query results at 2007-12-12 07:14:51 from Samantha Atkins
Re: what is the date format in binary query results at 2007-12-12 07:18:39 from Samantha Atkins

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2007-11-08 15:39:06	Re: "Resurrected" data files - problem?
Previous Message	hubert depesz lubaczewski	2007-11-08 14:48:04	why there is no interval / interval operator?