I have the following table def.
CREATE TABLE periods ( periodid serial NOT NULL, periodnumber integer NOT NULL, periodstart time with time zone, periodend time with time zone, PRIMARY KEY (periodid) ) This definition does not insert time zone. If I use without time zone then the time zone is inserted. If I input a time like: 01:05 AM then on select I get something like: 1970/01/01 01:05:00:00. If I use without time zone, then I get the correct date,time and time zone. The postgres version is 8.1 and I am using psycopg through Zope. I have date-style set to 'iso dmy' What I want is to just have the time inserted. Any ideas? regards garry ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
