On Thu, Nov 27, 2003 at 09:49:22AM +0100, Nhan NGO DINH wrote:
> Hi,
>
> This is really not a problem, may be in other circumstances...
> This output has been obtained from a PostgreSQL 7.3.4
>
> ===
> testdb=# select to_timestamp('23:20:30.123456', 'HH24:MI:SS.US')::time;
> to_timestamp
> -----------------
> 23:20:30.123459
> (1 row)
>
> testdb=# select to_timestamp('23:20:30', 'HH24:MI:SS.US')::time;
> to_timestamp
> --------------
> 23:20:30
> (1 row)
>
> testdb=# select to_timestamp('23:20:30', 'HH24:MI:SS.US')::time;
> to_timestamp
> -----------------
> 23:20:30.123459
> (1 row)
I think it's fixed in 7.4.
Karel
-- Karel Zak <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/