Re: invalid input syntax for type timestamp.
От | Hiroshi Saito |
---|---|
Тема | Re: invalid input syntax for type timestamp. |
Дата | |
Msg-id | 000f01c7203b$0317d000$0b01a8c0@yourc3ftrhkaod обсуждение исходный текст |
Ответ на | invalid input syntax for type timestamp. ("Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>) |
Ответы |
Re: invalid input syntax for type timestamp.
|
Список | pgsql-hackers |
----- Original Message ----- From: "Martijn van Oosterhout" >> I was doing the field test of Slony-I 1.2.2 release now. >> However, I encounter the problem of timestamp.:-( >> Was anyone recognizing this problem? > > The list of accepted timezones is now configurable, check through the > docs how to find the list and set it the way you want. > > OTOH, postgres never uses timezone identifiers in output, so I'm not sure > why it would need to care. Thanks. I do not think that this is normal..... As for 8.2.. SELECT timeofday()::timestamp; ERROR: invalid input syntax for type timestamp: "Fri Dec 15 14:26:05.502000 2006 JST" As for 8.1.5.. SELECT timeofday()::timestamp; timestamp------------------------- 2006-12-15 14:26:05.502(1 row) Regards, Hiroshi Saito
В списке pgsql-hackers по дате отправления: