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/YYYY HH24:MI:SS' (such as '05/01/2000 13:20:02'). Insertion is OK. But when we try to read this column, the output is '05/01/2000 13:20:02.20-04', which is not what we need. We don't need the '.20-04' part of the output, that is nano second and time zone part. Is there any ways that make the output doesn't contain the nano second and time zone part? Thnx a lot! Jack
