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)
===
Bye!
Nhan NGO DINH