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