Re: time without time zone

Garry Saddington wrote:
> 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

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

You don't say what version you're running, but I can't reproduce this
here on 8.2 - are you sure that table definition is right?

CREATE TABLE timetest (t1 time, t2 time without time zone, t3 timestamp
without time zone);
INSERT INTO timetest values (now(),now(),now());
SELECT * FROM timetest;
        t1        |       t2        |             t3
-----------------+-----------------+----------------------------
  21:12:30.346289 | 21:12:30.346289 | 2007-06-18 21:12:30.346289
(1 row)

--
   Richard Huxton
   Archonet Ltd