Re: timestamp Format on Binary Cursor

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Young" <jeff(at)muttworks(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: timestamp Format on Binary Cursor
Date: 2002-02-01 20:40:57
Message-ID: 12690.1012596057@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Jeff Young" <mailctl(at)muttworks(dot)com> writes:
> I have a timestamp column selected in a BINARY cursor coming back through
> the C PQ function PQgetvalue( ).
> I have not beem able to find it documented as to how to interpret those 8
> binary datetime/ timestamp bytes coming

It's a float8, representing seconds (counted from 2000/1/1 IIRC).

regards, tom lane

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jeff Eckermann 2002-02-01 21:11:18 Re: valide date in an ascii file
Previous Message dhoubrechts 2002-02-01 20:25:04 valide date in an ascii file