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