Re: Timestamp problem

Bernie Huang wrote:
> 
> 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?

You might want to check out the date/time and formatting functions at
http://www.postgresql.org/docs/postgres/index.html

Regards,
Ed Loehr