Re: [GENERAL] Return from timestamp column

2000-05-02 Thread Alfred Perlstein
* Jack Zhu <[EMAIL PROTECTED]> [000502 15:52] wrote: > 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 1

[GENERAL] Return from timestamp column

2000-05-02 Thread Jack Zhu
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