From: Bernie Huang <bernie.huang@ec.gc.ca>
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Timestamp problem
Date: Mon, 10 Jul 2000 11:52:26 -0700
Message-ID: <396A1B6A.E51A5499@ec.gc.ca> (raw)
Hi,
I have Postgres 7.0, and I created a table
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?
Thanks.
- Bernie
Attachments:bernie.huang.vcf (text/x-vcard, 314B) download
begin:vcard
n:Huang;Bernie
tel;fax:(604)664-9195
tel;work:(604)664-9172
x-mozilla-html:TRUE
org:Environment Canada;Standards and Technology Services
adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada
version:2.1
email;internet:bernie.huang@ec.gc.ca
title:Programmer
x-mozilla-cpt:;0
fn:Bernie Huang
end:vcard
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: bernie.huang@ec.gc.ca
Subject: Re: Timestamp problem
In-Reply-To: <396A1B6A.E51A5499@ec.gc.ca>
* 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