Timestamp problem

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Timestamp problem
Date: 2000-07-10 18:52:26
Message-ID: 396A1B6A.E51A5499@ec.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Attachment Content-Type Size
bernie.huang.vcf text/x-vcard 315 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Johnson 2000-07-10 18:56:08 Re: Matching and Scoring with multiple fields
Previous Message DalTech - Continuing Technical Education 2000-07-10 18:17:38 Re: problem with date