| 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: | Whole Thread | Raw Message | 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 |