Re: Timestamp Question - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Timestamp Question
Date
Msg-id 1089476382.1515.301.camel@localhost.localdomain
Whole thread Raw
In response to Timestamp Question  (Greg Markham <gmarkham@markhamdirect.com>)
List pgsql-jdbc
Greg,

I don't think you can get microseconds from your system. you can use
now() as the value to insert and it will get it from the server .

Dave
On Sat, 2004-07-10 at 12:01, 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
>
>
>
> !DSPAM:40f013d973729751036622!
>
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


pgsql-jdbc by date:

Previous
From: Greg Markham
Date:
Subject: Timestamp Question
Next
From: Tom Lane
Date:
Subject: Re: Error in DatabaseMetaData TableColumn lenght.dec