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 |
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 |