Timestamp problem

Поиск
Список
Период
Сортировка
От Bernie Huang
Тема Timestamp problem
Дата
Msg-id 396A1B6A.E51A5499@ec.gc.ca
обсуждение исходный текст
Список 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

Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: "DalTech - Continuing Technical Education"
Дата:
Сообщение: Re: problem with date
Следующее
От: Ed Loehr
Дата:
Сообщение: Re: Timestamp problem