time without time zone

Поиск
Список
Период
Сортировка
От Garry Saddington
Тема time without time zone
Дата
Msg-id 200706182047.22506.garry@schoolteachers.co.uk
обсуждение исходный текст
Ответы Re: time without time zone
Re: time without time zone
Список pgsql-general
Дерево обсуждения 
This is a select on table periods defined as such:
CREATE TABLE periods
(
  periodid serial NOT NULL,
  periodnumber integer NOT NULL,
  periodstart time without time zone,
  periodend time without time zone,
  PRIMARY KEY (periodid)
)

Periodid      Periodnumber      Periodstart      Periodend
6     1     2007/06/18 09:00:00 GMT+0     2007/06/18 09:30:00 GMT+0
7     2     2007/06/18 09:30:00 GMT+0     2007/06/18 10:00:00 GMT+0
8     3     2007/06/18 10:00:00 GMT+0     2007/06/18 10:30:00 GMT+0
9     4     2007/06/18 10:30:00 GMT+0     2007/06/18 11:00:00 GMT+0
10     5     2007/06/18 11:30:00 GMT+0     2007/06/18 12:00:00 GMT+0
11     6     2007/06/18 13:00:00 GMT+0     2007/06/18 13:30:00 GMT+0
12     7     2007/06/18 13:30:00 GMT+0     2007/06/18 14:00:00 GMT+0
13     8     2007/06/18 14:00:00 GMT+0     2007/06/18 14:30:00 GMT+0

Can anyone explain why time has todays date and time zone? I am confused, I
only want time, such as:
13:00:00
regards
garry

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