Postgres Pro
Downloads
Home   >   mailing lists

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

From Henshall, Stuart - Design & Print
Subject timeofday()::timestamp - not casting
Date
Msg-id E382B5D8EDE1D6118DBE0008C759BCD6116AF5@WCPEXCHANGE
Whole thread Raw
Responses Re: timeofday()::timestamp - not casting  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: createdb script bug in 7.3RC2?
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #824: Problem creating data base !!