Re: timestamp default values

On 8/7/05, Michael Fuhr <mike@fuhr.org> wrote:
> On Sun, Aug 07, 2005 at 12:05:43PM +1000, Brendan Jurd wrote:
> > => select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
> > ERROR:  22007: invalid input syntax for type timestamp: "Sat Aug 06
> > 12:00:43.668919 2005 EST"
>
> What are your timezone and australian_timezones settings?  I can
> duplicate the problem thusly:
>
> set australian_timezones to on;
> set timezone to 'EST';
> select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
> ERROR:  invalid input syntax for type timestamp: "Sat Aug 06 12:00:43.668919 2005 EST"
>
> set australian_timezones to off;
> select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
>          timestamp
> ----------------------------
>  2005-08-06 12:00:43.668919
> (1 row)
>
> --
> Michael Fuhr
>

=> show timezone;
   TimeZone
---------------
 Australia/ACT
(1 row)

=> show australian_timezones;
 australian_timezones
----------------------
 on
(1 row)

--
BJ