View Single Post

   
  #4 (permalink)  
Old 04-12-2008, 05:59 AM
Martijn van Oosterhout
 
Posts: n/a
Default Re: invalid input syntax for type timestamp.

On Fri, Dec 15, 2006 at 08:20:22PM +0900, Hiroshi Saito wrote:
> 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"


Err, sounds like a bug to me. Good ahead and file it. Should probably
change the timezone identifier to full form.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFgobAIB7bNG8LQkwRAszKAJ9v4W0ZdHnyWup6TAKe/n4ZixiepwCcDkUO
ICDYIJ9jSjcPkk1/c/l+qUU=
=u5jU
-----END PGP SIGNATURE-----

Reply With Quote