Dario V. Fassi wrote:
> You are seeing it:
>
> > test=> select '2004-07-10 12:59:59.123'::timestamp(6);
> > timestamp -------------------------
> > 2004-07-10 12:59:59.123
>
> I suggest that is cross DBs (eg. DB2 / PgSql etc) , the above
> situation cause troubles.
Sounds like it's not a JDBC problem though -- perhaps you should take it
up on pgsql-general or pgsql-sql?
> ** From a Jdbc client can see rows like:
> 2004-07-10 12:59:59.123
>
> in plase of:
>
> 2004-07-10 12:59:59.12300
> or
> 2004-07-10 12:59:59.00123
If you're using JDBC, you should be using ResultSet.getTimestamp(), not
interpreting the strings directly. Do you have a testcase that uses
getTimestamp() and sees an incorrect value?
-O