Re: Timestamp with libpq
Jakob Lechner <[email protected]> Mon, 13 Oct 2008 17:43:50 +0200
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Organization | appl.strudl Software GmbH |
| Message-ID | <[email protected]> |
Hi, Am Montag, den 13.10.2008, 14:59 +0200 schrieb Michael Meskes: > > I doubt this. It might be true for double storage but not for 8 byte integers, > well that is in the database of course. But I see no reason whatsoever that the > data is truncated by libpq. > I found an easy solution for my problem: Libpq provides information if the timestamps are double values or integer values. When passing the parameter "integer_datetimes" to the function "PQparameterStatus" "on" or "off" is returned. I adapted my conversion routine to handle both integer and double timestamps. Everything works fine now. Best regards Jakob -- Jakob Lechner Research & Development appl.strudl Software GmbH Honauerstraße 4 A-4020 Linz Tel.: [+43] (70) 60 61 62 Fax: [+43] (70) 60 61 62-609 E-Mail: [email protected] Web: http://www.applstrudl.com Handelsgericht Linz, FN 303988 t -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces