Thread: timestamp Format on Binary Cursor

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

"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