Re: timeofday()::timestamp - not casting

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: timeofday()::timestamp - not casting
Date: 2002-11-28 16:25:47
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116AF7@WCPEXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> "Henshall, Stuart - Design & Print"
> <SHenshall(at)westcountry-design-print(dot)co(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Lee Kindness 2002-11-28 17:52:28 Fw: CD
Previous Message Tom Lane 2002-11-28 15:10:59 Re: timeofday()::timestamp - not casting