Re: time type strange behaviour
От | garry saddington |
---|---|
Тема | Re: time type strange behaviour |
Дата | |
Msg-id | 1160496974.13498.17.camel@localhost обсуждение исходный текст |
Ответ на | Re: time type strange behaviour (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: time type strange behaviour
|
Список | pgsql-general |
On Tue, 2006-10-10 at 11:58 -0400, Tom Lane wrote: > garry saddington <garry@schoolteachers.co.uk> writes: > > 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. > > Better look again --- if you get that output, the column is most > certainly not a time column --- it must be timestamp. Perhaps you > got confused about which table is which? > > regards, tom lane No, there is no confusion, I have dropped it, re-made it and tested it again, same result. I know it sounds odd but this is what happens! Garry
В списке pgsql-general по дате отправления: