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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
