Re: invalid input syntax for type timestamp. - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: invalid input syntax for type timestamp.
Date
Msg-id 20061215112800.GF958@svana.org
Whole thread Raw
In response to Re: invalid input syntax for type timestamp.  ("Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: [PERFORM] EXPLAIN ANALYZE on 8.2
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: unixware and --with-ldap