On Monday 18 June 2007 21:15, Tom Lane wrote: > Garry Saddington <garry@xxxxxxxxxxxxxxxxxxxx> 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 > ----------+--------------+----------------+---------------- > 1 | 1 | 16:13:14.35962 | 16:13:14.35962 > (1 row) > > I speculate that you are trying to display the table in some client > software that doesn't know the time datatype and is forcibly converting > it to something it does know. > > regards, tom lane Yes, you are correct I am in Zope using ZpsycopgDA. Just tried on the command line and the behaviour is correct. Time to ask elsewhere, thanks. regards garry
