From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Peter T Mount <peter@taer.maidstone.gov.uk>
To: Aleksey Demakov <avd@gcom.ru>
Cc: pgsql-interfaces@postgreSQL.org, Peter T Mount <peter@retep.org.uk>
Subject: Re: [INTERFACES] JDBC, Timestamps, and DateStyle
Date: Tue, 27 Oct 1998 15:02:43 +0000
Message-ID: <3635E093.311004E1@alumni.caltech.edu> (raw)
References: <Pine.LNX.3.96.981027105346.4458F-100000@taer.maidstone.gov.uk>
> > But it is not my main problem since I can set DateStyle by myself.
> > The other problem is that the driver simetimes fails to parse
> > timestamps.
> > ... The timestamp can contain fractions of second.
If this is the actual Postgres timestamp data type, it should not be
showing fractional seconds afaik. It would be good to be able to handle
that, since sometime soon it will become more like the datetime type,
but at the moment it is implemented as a "seconds from 1970" integer. So
the code which decides whether or not to print fractions should never
see a fraction to print...
Also, afaik timestamp always prints in the "ISO-8601" format as a
feature from the original implementer. I think he was wanting some M$
interoperability. I kept that convention when I rewrote the I/O for the
data type, but I'm not sure if it is desirable in the long run.
Are you _sure_ you are talking about the timestamp type??
- Tom
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: lockhart@alumni.caltech.edu, peter@taer.maidstone.gov.uk, avd@gcom.ru, peter@retep.org.uk
Subject: Re: [INTERFACES] JDBC, Timestamps, and DateStyle
In-Reply-To: <3635E093.311004E1@alumni.caltech.edu>
* 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