[HACKERS] timestamp convert function

[Nhan NGO DINH]

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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match