Re: timeofday()::timestamp - not casting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "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 15:10:59
Message-ID: 14028.1038496259@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Henshall, Stuart - Design & Print 2002-11-28 16:25:47 Re: timeofday()::timestamp - not casting
Previous Message pgsql-bugs 2002-11-28 15:07:25 Bug #824: Problem creating data base !!