| From: | Igor Roboul <igor(at)raduga(dot)dyndns(dot)org> |
|---|---|
| To: | pgsql-general(at)hub(dot)org |
| Subject: | Timestamp |
| Date: | 2000-10-27 09:45:11 |
| Message-ID: | 20001027134511.A25235@linux.rainbow |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
How to get value of 'timestamp' type field into C program?
For example for varchar(x) I use v = PQgetvalue(r,0,0) and now
v is pointer to nullterminated string.
For integer: i = PQgetvalue(r,0,1) and now i contains value
of integer field.
But with timestamp? How to translate returned value into time_t?
I could not find this in documentation (in aw_pgsql_book and in manual
pages). I have installed postgresql-7.0.2 using FreeBSD port.
--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike E | 2000-10-27 11:13:13 | Time Difference |
| Previous Message | Oliver Elphick | 2000-10-27 07:08:09 | What is the listserver at hub.org doing? |