Re: Timestamp Question

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