timeofday()::timestamp - not casting

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: timeofday()::timestamp - not casting
Date: 2002-11-28 11:46:02
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116AF5@WCPEXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Diego Zuccato 2002-11-28 13:23:01 Memory leak detected
Previous Message Monson Marukatat 2002-11-28 07:58:33 Fw: CD