Re: Time and date functions give me headaches!! - Mailing list pgsql-general

"Costin Manda" <siderite@madnet.ro> writes:
> select setuptime::timestamp from billing; - error (cannot cast type
> character varying to timestamp without timezone!?)

It works for me in 8.0.  In some releases you need to cast to text
first, for example in 7.4:

regression=# select '2005-10-10 10:10:10'::varchar::timestamp;
ERROR:  cannot cast type character varying to timestamp without time zone
regression=# select '2005-10-10 10:10:10'::varchar::text::timestamp;
      timestamp
---------------------
 2005-10-10 10:10:10
(1 row)


            regards, tom lane