Re: Timestamp Question

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