Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: timeofday()::timestamp - not casting
Date
Msg-id 14028.1038496259@sss.pgh.pa.us
Whole thread Raw
In response to timeofday()::timestamp - not casting  ("Henshall, Stuart - Design & Print" <SHenshall@westcountry-design-print.co.uk>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #824: Problem creating data base !!
Next
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: timeofday()::timestamp - not casting