timeofday()::timestamp - not casting

Started by Henshall, Stuart - Design & Printover 23 years ago3 messagesbugs
Jump to latest
#1Henshall,	Stuart - Design & Print
SHenshall@westcountry-design-print.co.uk

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Henshall, Stuart - Design & Print (#1)
Re: timeofday()::timestamp - not casting

"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

#3Henshall,	Stuart - Design & Print
SHenshall@westcountry-design-print.co.uk
In reply to: Tom Lane (#2)
Re: timeofday()::timestamp - not casting

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