Re: timeofday()::timestamp - not casting - Mailing list pgsql-bugs

From Henshall, Stuart - Design & Print
Subject Re: timeofday()::timestamp - not casting
Date
Msg-id E382B5D8EDE1D6118DBE0008C759BCD6116AF7@WCPEXCHANGE
Whole thread Raw
In response to timeofday()::timestamp - not casting  ("Henshall, Stuart - Design & Print" <SHenshall@westcountry-design-print.co.uk>)
List pgsql-bugs
Tom Lane wrote:
> "Henshall, Stuart - Design & Print"
> <SHenshall@westcountry-design-print.co.uk> writes:
>> dev=# select timeofday()::timestamp;
>> ERROR:  Bad timestamp external representation 'Thu Nov 28
>> 11:26:46.488000 2002 GMTST'
>
> It works for me.  Where in the world is cygwin getting "GMTST" from
> --- surely that's not a real timezone name?
>
>             regards, tom lane
Just rechecked & 7.2.3 doesn't work on my machine (win9x - I'd been lazy and
just connected to a server to check 7.2 which is NT4).
Hmmm... maybe GMT daylight Saving Time? Oh well will try and investigate to
see if anything is wrong, or if this is a win9x peculiarity (strongly
suspected).
Thanks,
- Stuart

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: timeofday()::timestamp - not casting
Next
From: "Monson Marukatat"
Date:
Subject: Fw: CD