Re: Timestamp Question

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.