Thread: Another date/time question using libpq

Using a stored procedure (function in Postgres), I insert data which contains a column called "creation_dt". Here I insert that date/time the row was created. With psql I can view and confirm the data with a select statement. My problem is retrieving the columns infornation from the result using PQgetvalue. More specificly, how/what data type to use. PQgetvalue returns a char * and I'm unfamilar with how to or what to cast this as that will return the result I need. If someone could demonstrate what data type to return/cast from the PQgetvalue and how to format that inot a date format I would be very appreciative.  Here's the function and insert statement I'm using:

 

.

.

.

BEGIN

v_creation_date := CURRENT_TIMESTAMP;

 

insert into mytable (creation_dt) values v_creation_date;

 

END;

 

TIA

Tom

 

BTW I'm not subscribed.