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
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 |