Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp Format on Binary Cursor - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: timestamp Format on Binary Cursor
Date
Msg-id 12690.1012596057@sss.pgh.pa.us
Whole thread Raw
In response to timestamp Format on Binary Cursor  ("Jeff Young" <mailctl@muttworks.com>)
List pgsql-interfaces
Tree view 
"Jeff Young" <mailctl@muttworks.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

pgsql-interfaces by date:

Previous
From: "David Pinelo"
Date:
Subject: Best method of access to PostgreSql using VBA in Microsoft Access
Next
From: dhoubrechts
Date:
Subject: valide date in an ascii file