Thread: 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/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

* Jack Zhu <jzhu@netcom-sys.com> [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/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!

I think the date_trunc() function is what you need to use.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."