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 [email protected]
Whole thread Raw
In response to Re: invalid input syntax for type timestamp.  ("Hiroshi Saito" <[email protected]>)
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   <[email protected]>   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: [email protected]
Date:
Subject: Re: unixware and --with-ldap