Re: Timestamp Question - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Timestamp Question
Date
Msg-id 1089638275.11544.334.camel@localhost.localdomain
Whole thread Raw
In response to Re: Timestamp Question  ("Dario V. Fassi" <software@sistemat.com.ar>)
List pgsql-jdbc
Dario,

Just to give you the big picture, postgresql does not have a company
overseeing development, all development is done by volunteers. They
primarily work on what is of interest to them. That being said, we
gladly accept patches for whatever interests you. In other words you
will get further supplying a patch than just saying something doesn't
work the way you think it should. As a word of advice, postgresql aims
to be SQL compliant, so patches that are not compliant are likely to be
refused. As an example, if you wanted some xyz feature "like Oracle does
it" for instance it would likely be refused.

Dave
On Sun, 2004-07-11 at 15:18, Dario V. Fassi wrote:
> Dave Cramer wrote:
>
> >the real question is where do you get microsecond values from in java,
> >and are they real? In other words, if you are getting system time in
> >microseconds ( if that's even possible ) it will take you a few more
> >microseconds to insert it.
> >
> >Dave
> >
> >
> Dave, it's true that in Java and PC hardware almost microseconds is the
> max time discrimination possible.
> But re-read my post (and excuse my horrible English),
> I say that would help a lot if the microseconds part of a timestamp will
> be zero padded to a minimum length of 5 or 6 digits.
>
> Like:
>
> "then most databases can take 2004-07-10 12:59:59.123 as 2004-07-10 12:59:59.123000 "
>
> This behavior help is cross (vendor) database operations .
>
> Dario.
>
> >On Sat, 2004-07-10 at 13:20, Dario V. Fassi wrote:
> >
> >
> >>Greg Markham wrote:
> >>
> >>
> >>
> >>>I have searched the archives and not found and answer to this question:
> >>>
> >>>I am trying to use a Java Timestamp object to create a Postgresql
> >>>Timestamp(6) field.  I can insert a Timestamp but it only goes to the
> >>>millisecond(2004-07-10 12:59:59.123) I need it to the microsecond
> >>>(2004-07-10 12:59:59.123456).  Is there a way to do this?
> >>>
> >>>- Greg Markham
> >>>
> >>>
> >>I have the same problem, and It's very molest in cross-dabase operations
> >>(read in one and write in another vendor db).
> >>
> >>A workaround to this problem is create tables using   "TIMESTAMP WITHOUT
> >>TIMEZONE",  then most databases can take 2004-07-10 12:59:59.123 as
> >>2004-07-10 12:59:59.123000 , but the real value could be 2004-07-10
> >>12:59:59.000123.
> >>
> >>I think that If the microseconds come zero padded , simplify many
> >>things, even insert  TIMESTAMP WITH TIMEZONE values on other databases
> >>where timestamps is always represented in Local time (without timezone).
> >>
> >>Dario Fassi.
> >>
> >>
> >>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
>
> !DSPAM:40f192229421573712783!
>
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: patch for getXXX methods
Next
From: Oliver Jowett
Date:
Subject: Re: patch for getXXX methods