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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
