On Monday 18 June 2007 21:15, Tom Lane wrote:
> Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> 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