From: Roberto Taglioretti <roberto@gass.it>
To: pgsql-interfaces@postgresql.org
Subject: C program Postgres 6.3 and date
Date: Sun, 02 May 1999 23:46:26 +0200
Message-ID: <372CC7B2.FEF11BFB@gass.it> (raw)
Hello,
first thing of note is that I'm not on the list so please email
solutions to me.
I recently upgraded postgres from version ~6 to 6.3. Unfortunately,
where before I had everything passed back as text strings now things are
being passed back in their binary form.
My question is
How is the postgres date type stored in C?
Is it an integer in seconds from a specific date?
How would I convert it to a text string of the form 05-21-1998?
(When I print it as an integer I get 841823536)
Before I received that text string as a result of the PQgetvalue now
I am getting the binary form and I can't find a reference on how to
convert
back.
Thanks
Roberto Taglioretti
--
_____________
Taglioretti Roberto (roberto@gass.it)
our sites:
http://www.gass.ithttp://www.gassnet.nethttp://www.itbusiness.comhttp://www.immagini.it
our legal address:
GASS s.a.s di Grampa M. e Taglioretti R. & C.
Via delle Cascine 38
21041 Albizzate (VA) ITALY
P.I. 02290890124
Telephone +39(0)331 985251
Fax +39(0)331 984497
our operative site address:
GASS s.a.s di Grampa M. e Taglioretti R. & C.
Via Col Di Lana 18
21041 Albizzate (VA) ITALY
P.I. 02290890124
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: roberto@gass.it
Subject: Re: C program Postgres 6.3 and date
In-Reply-To: <372CC7B2.FEF11BFB@gass.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox