Thread: timestamp Format on Binary Cursor

timestamp Format on Binary Cursor

From
"Jeff Young"
Date:
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
back.

Any help is appreciated.

Jeff





Re: timestamp Format on Binary Cursor

From
Tom Lane
Date:
"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