From: Ed Loehr <eloehr@austin.rr.com>
To: Bernie Huang <bernie.huang@ec.gc.ca>
Cc: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: Timestamp problem
Date: Mon, 10 Jul 2000 14:07:31 -0500
Message-ID: <396A1EF3.A0D7598B@austin.rr.com> (raw)
References: <396A1B6A.E51A5499@ec.gc.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: eloehr@austin.rr.com, bernie.huang@ec.gc.ca
Subject: Re: Timestamp problem
In-Reply-To: <396A1EF3.A0D7598B@austin.rr.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox