Received: from venere.inet.it (venere.inet.it [194.20.8.4]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA98514 for ; Sun, 2 May 1999 19:01:27 -0400 (EDT) (envelope-from roberto@gass.it) Received: (from trusted@localhost) by venere.inet.it (8.9.3/8.9.3) id BAA277314 for ; Mon, 3 May 1999 01:01:26 +0200 Received: from gassisdn.inet.it(194.185.143.108) by venere.inet.it via I-SMTP id queue/s-194.185.143.108-6vv.qa; Mon May 3 01:01:25 1999 Received: from gass.it (roberto.gass.it [192.168.1.103]) by linux.gass.it (8.8.5/8.8.5) with ESMTP id XAA20284 for ; Sun, 2 May 1999 23:36:59 +0200 Message-ID: <372CC57B.930F5817@gass.it> Date: Sun, 02 May 1999 23:36:59 +0200 From: Roberto Taglioretti Organization: GASS s.a.s. di Grampa M. e Taglioretti R. X-Mailer: Mozilla 4.51 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: C program Postgres 6.3 and date Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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.it http://www.gassnet.net http://www.itbusiness.com http://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