Skip site navigation (1) Skip section navigation (2)

Re: Timestamp Summary

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <c(dot)s(dot)cryder(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Timestamp Summary
Date: 2005-07-25 17:13:25
Message-ID: s2e4d773.097@gwmta.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-jdbc
As someone who is interested in timestamp columns only to hold actual
moments in time, I'm very uncomfortable with Christian's proposed "fix".
 We have a highly multithreaded environment dealing with multiple
database servers.  Having various threads all setting the default
timezone for the JVM to something inaccurate based on connections to a
variety of servers seems likely to break much more than it fixes.  The
primary "problem" being solved by this technique is that it is hard to
record a timestamp representing a moment which doesn't exist any more
than do the following:
 
2005-02-29 00:00:00.0
2005-10-35 00:00:00.0
2005-10-25 00:75:00.0
 
It is fine with me if moments that don't exist can't be stored in the
database.  Others have pointed out problems with storage and retrieval
of valid Timestamp objects.  Those seem to me to be the problems to
address.  I think that would go part of the way toward addressing
Christian's problems; but, since you can't actually create a Timestamp
object within a JVM set to the correct time zone to represent what he
wants, his particular issue will always require munging the Java runtime
environment, which is simply not an option in many situations.
 
-Kevin
 



Responses

pgsql-jdbc by date

Next:From: Mark LewisDate: 2005-07-25 17:16:52
Subject: Re: Timestamp Summary
Previous:From: Christian CryderDate: 2005-07-25 16:45:25
Subject: Timestamp Summary

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group