| From: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | time without time zone |
| Date: | 2007-06-18 19:47:22 |
| Message-ID: | 200706182047.22506.garry@schoolteachers.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2007-06-18 20:06:22 | Re: unexpected shutdown |
| Previous Message | developer | 2007-06-18 19:39:24 | Re: unexpected shutdown |