Postgres Pro
Downloads
Home   >   mailing lists

time without time zone - Mailing list pgsql-general

From Garry Saddington
Subject time without time zone
Date
Msg-id 200706182047.22506.garry@schoolteachers.co.uk
Whole thread Raw
Responses Re: time without time zone
Re: time without time zone
List pgsql-general
Tree view 
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 by date:

Previous
From: developer@wexwarez.com
Date:
Subject: Re: unexpected shutdown
Next
From: Francisco Reyes
Date:
Subject: Re: unexpected shutdown