Date/Time atributes and binary cursors - Mailing list pgsql-interfaces

From Gonçalo Marrafa
Subject Date/Time atributes and binary cursors
Date
Msg-id 20040402155110.14a956a1.gjm@uevora.pt
Whole thread Raw
Responses Re: Date/Time atributes and binary cursors  (L J Bayuk <ljb220@mindspring.com>)
List pgsql-interfaces
Hi there.

I'm trying to read a timestamp without timezone attribute, using binary cursors. I can read the data but i don't know
whatto do with it. I would like to convert it to a time_t or tm struct. How can i do this? 

I'm using postgresql 7.4 on Debian sid.

Here's a snippet of the code i'm using:

...
#include <postgresql/pgtypes_timestamp.h>
...
timestamp *ts; ts = (timestamp *) PQgetvalue(res, i, f_num);


I would like to use date attributes too.

Thanks in advance.

--
Gonçalo Marrafa <gjm@uevora.pt>

pgsql-interfaces by date:

Previous
From: Adriaan Joubert
Date:
Subject: Bug in translation of DEALLOCATE PREPARE
Next
From: Mikhail Ts
Date:
Subject: PostgreSQL 7.4.2 libpq problem