Re: timestamp default values

On 8/7/05, Michael Fuhr <mike(at)fuhr(dot)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