timeofday()::timestamp - not casting
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
"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
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
Import Notes
Resolved by subject fallback