[GENERAL] Return from timestamp column

Hi, all: PostgreSQL 7 Beta 5 on Red hat Linux 6.0 We have a a table which has a column col_a with 'timestamp' data type. When insert time value to this column, we use format which is 'MM/DD/ HH24:MI:SS' (such as '05/01/2000 13:20:02'). Insertion is OK. But when we try to read this column, t

[GENERAL] JDBC problem on Postgresql 7 beta 5

Hi, PostgreSQL 7 Beta 5 on Red hat Linux 6.0 JDBC 6.5-1.1 driver, Java 1.1.7B, download JDBC driver from http://www.retep.org.uk/postgres/ We have a a table which has a column col_a with 'timestamp' data type. When insert time value to this column, we use format which is 'MM/DD/ HH24:MI:SS'