Thread: timeofday()::timestamp - not casting

timeofday()::timestamp - not casting

From
"Henshall, Stuart - Design & Print"
Date:
From 7.2.3:
dpt=> select timeofday()::timestamp;
          timeofday
------------------------------
 2002-11-28 11:47:37.06366+00
(1 row)


all OK however from 7.3rc2 (on cygwin):
dev=# select timeofday()::timestamp;
ERROR:  Bad timestamp external representation 'Thu Nov 28 11:26:46.488000
2002 G
MTST'
dev=# select timeofday();
               timeofday
---------------------------------------
 Thu Nov 28 11:26:59.454000 2002 GMTST
(1 row)

- Stuart

Re: timeofday()::timestamp - not casting

From
Tom Lane
Date:
"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

Re: timeofday()::timestamp - not casting

From
"Henshall, Stuart - Design & Print"
Date:
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