Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Diego ZuccatoDate: 2002-11-28 13:23:01
Subject: Memory leak detected
Previous:From: Monson MarukatatDate: 2002-11-28 07:58:33
Subject: Fw: CD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group