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
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:[EMAIL PROTECTED]
title:Programmer
x-mozilla-cpt:;0
fn:Bernie Huang
end:vcard

Reply via email to