Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54])
	by hub.org (8.10.1/8.10.1) with ESMTP id e6AJ3RW85858
	for <pgsql-sql@postgresql.org>; Mon, 10 Jul 2000 15:03:27 -0400 (EDT)
Received: from austin.rr.com ([24.28.74.65]) by mail.austin.rr.com with
	Microsoft SMTPSVC(5.5.1877.357.35); Mon, 10 Jul 2000 14:04:49 -0500
Message-ID: <396A1EF3.A0D7598B@austin.rr.com>
Date: Mon, 10 Jul 2000 14:07:31 -0500
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Bernie Huang <bernie.huang@ec.gc.ca>
CC: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: Timestamp problem
References: <396A1B6A.E51A5499@ec.gc.ca>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200007/107

Bernie Huang wrote:
> 
> table
> ---------
> ...
> borrow timestamp
> return timestamp
> 
> Now, I thought timestamp is in sec eg; 35434434, but in PostgreSQL, it
> shows up as datetime datatype eg; 2000-06-07 17:00:05-07.
> 
> I was wondering is this format a correct one for timestamp, or is it a
> bug?  Abd if I want to show the time, each retrieval I have to chop of
> the '-07' timezone at the end.  Is there a way to avoid this being show
> up in Postgres?

You might want to check out the date/time and formatting functions at

	http://www.postgresql.org/docs/postgres/index.html

Regards,
Ed Loehr