Re: invalid input syntax for type timestamp.

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org, Devrim GUNDUZ <devrim(at)commandprompt(dot)com>, Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
Subject: Re: invalid input syntax for type timestamp.
Date: 2006-12-15 11:28:00
Message-ID: 20061215112800.GF958@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ohp 2006-12-15 11:28:25 Re: unixware and --with-ldap
Previous Message Dimitri Fontaine 2006-12-15 11:24:35 Re: [HACKERS] EXPLAIN ANALYZE on 8.2