timestamp convert function

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/

Karel Zak <zakkr@zf.jcu.cz> writes:

On Thu, Nov 27, 2003 at 09:49:22AM +0100, Nhan NGO DINH wrote:

This output has been obtained from a PostgreSQL 7.3.4

I think it's fixed in 7.4.

Yes. The patch will also be in 7.3.5 when we release that (probably in
the next week or so).

regards, tom lane