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 по дате отправления: