Re: Timestamp Question - Mailing list pgsql-jdbc

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


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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if
> > your  joining column's datatypes do not match
>
>
> 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 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
> !DSPAM:40f024f6178417078914163!
>
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


pgsql-jdbc by date:

Previous
From: "Antony Paul"
Date:
Subject: No class found for inet
Next
From: Oliver Jowett
Date:
Subject: Re: Timestamp Question