Re: Output from 'timestamp' column!?

You just need to cut this column. e.g. use perl you can use:
new_column = substr(old_column, 0,  19)

Or you can use the function to convert to what you want  when you select this
column from the table. Check functions

--
Banghe

Jack Zhu 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/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