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.