On Monday 18 June 2007 21:15, Tom Lane wrote:
> Garry Saddington <[EMAIL PROTECTED]> writes:
> > Can anyone explain why time has todays date and time zone?
>
> Works for me:
>
> regression=# insert into periods values(1,1,'now','now');
> INSERT 0 1
> regression=# select * from periods;
> periodid
Garry Saddington <[EMAIL PROTECTED]> writes:
> Can anyone explain why time has todays date and time zone?
Works for me:
regression=# insert into periods values(1,1,'now','now');
INSERT 0 1
regression=# select * from periods;
periodid | periodnumber | periodstart | periodend
--+-
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)
)
PeriodidPeriodnumberPeri
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)
)
PeriodidPeriodnumberPeriodstart Periodend
6
